Web Application Designer - Analysis Item

[Former Member]

Hi Experts,

We are using Analysis Iten property (Column From And Colum To) to display one few key figures from Query. This is because we are using same query for differnt Analysis items with differnt key figures.Now issue is we are having few key figure nodes collapsed in Quey designer. Analysis item is not considering the sub key figures of collapsed note. So whenever we expand a node a run time,the key figures at the end are not getting displayed. Please provide any solution for this issue.

Thanks in Advance,

Reshma M

[Former Member]

It is because the column numbering changes when you expand a collapsed keyfigure.

Create a query view with the keyfigure(s) that you need for the analysis web item. Then use this query view for the analysis web item and remove the settings on Column From/To properties.

Regards

Francis