Creating a calculated item in C8 Report Studio

[ranne_78]

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,

[dimi]

Hi

Did you try to use the ancestors function?

if you prompt for 100A -> something like: ancestor([Projectid ];1)

Hope this helps