Hi all,
i have 2 prompts A and B. I am using a dimensional package, the source for these prompts is the root hierarchy itself and they have suitable filters to get different data in both prompts.
Now for the report query i have added a filter/slicer like this
if
(?A? is null) and (?B? is not null)
then
([Cube].[dimension].[HierarchyI] -> ?B?)
else if
(?A? is not null) and (?B? is null)
then
([Cube].[Dimesion].[HierarchyI] -> ?A?)
else if
(?A? is not null) and (?B? is not null)
then
([cube].[Dimension].[HierarchyI] -> ?B?)
I am getting parsing errors for this.
Assuming Cognos behaves funnily with multiple if-else blocks is there any other way to write the above code.
Please help..
What are the errors you are getting?
MF.
We managed to solve the errors.. thank you