If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Parsing errors while adding a filter/slicer

Started by suhas_bhat, 13 Oct 2010 04:46:06 AM

Previous topic - Next topic

suhas_bhat

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..

MFGF

Meep!

suhas_bhat

We managed to solve the errors.. thank you