Hierarchy variable in Webi report

[simon_iglesias]

Dear all ,

I'm expirence some problems in the Olap Universe , my question is :

I can't see data in Webi report .

Step 1 Create the webi report

Step 2 Run the query

Step 3 Select the Hierarchy variables in prompt parameter

Step 4 Get the msg "No data to retreive "

I can see the data in BW with this Hierarchy variable so i don't understand what it's missing .

Thanks a lot

Bst Rgds

Simon

[simon_iglesias]

Solved by customer , something wrong in BW side

[steve_norton]

Hello,

I've moved this post to a more appropriate forum.

The OnDemand forum is specifically for applications like crystalreports.com or bi.ondemand.com.

Cheers

Steve

[Former Member]

can u please give some more additonal information regarding this scenario.

try using the correct values in variables when running the query.

[simon_iglesias]

Dear Sanket ,

Thanks for your response , We are using the dimension it's a member of one hierarchy in the query panel without any filter .

BOE release 3.1 Sp3

BW 7.01 SP6 .

Hope this helps , any further question please let me know .

Bst Rgds

Simon

[Former Member]

Simon,

One thing that I've come across is that you often need to add a key figure to a report to get data back - row count usually works a treat.

Regards,

Mark

[simon_iglesias]

Hi Mark ,

Thanks for your response , actually I've the hierarcy variable dimension (Key figure ) and one metric .

Bst Rgds

Thanks a lot

Simon