Skip to Content
author's profile photo Former Member
Former Member

Inverse Routine - For Hierarchies on Virtual Cube

Hi All,

I have written an Inverse routine in the start routine(Physical cube ->Transformation-> Virtual Cube -> Report)

I am using one of the the Query input variable as Hierarchy variable, but default value based on the hierarchy is not getting picked up. The result would always come as No data found, but when we drill down into the child node single value in the variable input screen, the query picks up the data and is getting displayed.

Have anyone of you used Hierarchy based variables in the inverse routine?

Note: When the same hierarchy variable used on the physical cube, data is getting picked and displayed, so the problem is with the Inverse routine on restricting the Hierarchy variable.

Waiting for your helpful responses.



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Aug 20, 2015 at 01:40 PM


    I have a work around, I added a dummy infoobject = constant =X. to my virtual cube.

    In my bex report I filter on that infoobject =X. In my inverse routine, I see the obect, so I know the query has to be filterd by the hierarchy in that query. So for each query I have just one hierarchy with such an infoobject. Absolutely **** solution. But it restricts and my performance is much better. I'm searching for a good solution as well. If you know one, please share !!!!



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.