Hi guys,
I hav an issue on creating calculated items in C8 Report studio.
We r using Powerplay cube (MDC file) as a datasource. By using that we r creating reports in report studio. I created a report with prompt on Project id. In the result page(cognos viewer) I want to see the parent of that project id.
Ex: I am promting on Projectid lets say 100 this project id has childs like 100A,100B,100c.
when I prompted on 100A I want to see 100A parent 100 in the result page by driling up.
To do this I am trying to create Calculated item with functions Level/ Hierarchy. But I am not getting the result as mentioned above. Give me a clue to solve this issue.
Best wishes,
Hi
Did you try to use the ancestors function?
if you prompt for 100A -> something like: ancestor([Projectid ];1)
Hope this helps