Hi.
I have a dimension with organizational structure, one prompt with organozational structure and fact table with 5 measures. I need to show 5 measures for each organization entity one level below the selected level, including selected organization.
for example, the output should be something like this:
------------------------------------------------------------------------
| <org>|measure 1|measure 1|measure 1|measure 1|measure 1|
------------------------------------------------------------------------
|org1.1| | | | | |
------------------------------------------------------------------------
|..........| | | | | |
------------------------------------------------------------------------
|org1.n| | | | | |
------------------------------------------------------------------------
|org1 | | | | | |
------------------------------------------------------------------------
There is requirement that all rganization entity one level below the selected level should be sorted descending by measure 1 and the selected organization should be exactly last record in the table.
Does anybody know how to do that?
thanks/