Skip to Content
author's profile photo
Former Member

Reporting

Hi Experts

when the report is executed we get the results in excel sheet1 and we have more sheet2 and sheet3 blank. now if i want to get a new query in sheet2 from the different cube, is it possible?

i mean in <b>sheet1</b> i am executing a query from CUSTOMER CUBE and in <b>sheet2</b> i want a query to be executed from DELIVERY CUBE. (without using RRI). can anyone please help me with answer. Thanks

Regards

Kanth.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Sep 02, 2005 at 05:04 AM

    Hi Kanth,

    Yes..It is possible. For that you would need to create a workbook. Go to sheet 2 -> Tools(from menu) -> Insert Query. Ater selecting the query and executing it. Save the excel files as workbook.

    Hope it helps.

    Bye

    Dinesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello kanth,

      i know this method, but if you have for each sheet a variable . When query is executed, first varaible appeared (normal) but, for the second sheet:

      if the variable is the same ?? is it known automatically in second sheet (then did't appear)or is it repeated??

      if the variable is different??

      the objectif is to recuperate the variable in second sheet in make a calcul.

      example:

      enter date mmyyyy in 1 sheet (name Y) put at screen "DATE: $Y$"

      recuperate date in 2 sheet in create a formula with X = Month(Y) in put at screen "MONTH: $X$"

      THANK YOU for help

  • author's profile photo
    Former Member
    Sep 02, 2005 at 04:50 AM

    Even i am interested .......

    Ravindra.

    Add comment
    10|10000 characters needed characters exceeded