How to work with Conditions against Powerplay cube - Not solved but closed

[MellBI]

Hi All,

I am trying to create a new Data Item using Dimensional data. The problem for me is that my goal is to solve a situation that i would have solved like this if it was relational.
if (Region = ?pGeography?) Then (Amount) ELSE (0)
Region and Amount are existing Data Items.

If I hardcode like the following it works fine.
if((CAPTION([US COMMISSION INDICATOR (visible items with calculations set)])) ='US NY/NJ' )  THEN ([Amount USD]) ELSE (NULL)
Point is that I need to compare with the parameter instead.

Any ideas?

Regards
MellBI

[CognosPaul]

Hi MellBI,

It looks like you're new to dimensional reporting. I'd recommend reading up on it:
IBM Cognos BI Dimensional Functions and Writing Efficient OLAP Queries.

To answer your question, you should be able to do something tuple(Amount,?pGeography?)

[MellBI]

Hi,
I am not totally new to Dimensional reporting but this causes me some trouble :(

Actually I tried the tuple but my prompt for my Parameter then changed behaviour.
I used to have a tree prompt with several geographical locations but when I use Tuple I only get the top level in the prompt.

/MellBI

[CognosPaul]

That's very odd. So when you attempt a tuple the measure isn't sliced?

Do you have any other detail filters in the report? Mixing relational and dimensional techniques tends to cause unpredictable results.

For a test, try placing the prompt into the slicer of the query. See if that effects the measure.

[MellBI]

Hi,

I tried to use the Parameter as a slicer and got the same behaviour, just the top level.
There is a filter defined but removing that do not change anything.

Then it might be related to the Parameter instead



/MellBI

[MellBI]

Hi,

I gave up and redesigned the report a little bit and now i use another way of displaying the data where I do not need this functionality.

Thanks for your support.

/MellBI

[barrysaab]

Could you please share, what method you actually employed.Thanks