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.