Select 1 measure among many

agor · Posted: Mon Feb 08, 2010 12:43 pm Post subject: Select 1 measure among many

Hi all,

I have a report with 1 dimension and 3 measures.

I have a table with 2 columns : one for my dimension and the other for 1 of the 3 measures.

I want to create a variable with the name of my 3 measures allowing me to select 1 of the 3.

Any idea ?

Thanks in advance

Alex

Marek Chladny · Forum Devotee Joined: 27 Nov 2003 Posts: 10327

Hi,

Do you want to do it in the universe as a new universe object?

agor · Posted: Mon Feb 08, 2010 9:13 pm Post subject: Re: Select 1 measure among many

Hello Marek,

Thank you for your answer.

Eventualy, I figured a way out by asking my DBA to modify the fact table (derived table in the universe).

Instead of having this structure : Dimension / Measure1 / Measure2
...now we have : Dimension / Measure Name / Measure value.

This allows me to "filter" the measure used in a table.

I know that this is not a best practice as we shouldn't adapt the DB to answer lacks of the reporting tool and I would have prefered to find a solution in the report but still, it works...

Thanks anyway and if someone has a solution applicable at the report level, I'm still interested.

Alex