Dimension picklist link

[artikh]

Dear all,

i have a cube, and some dimensions related in perspective using picklist.

dimension = DEPT
elements = West, East, South
--------------------------------------------------#
dimension = REG
elements =
West
-- Area1
-- Area2
East
-- Area3
-- Area4
South
-- Area5

in dimension REG, i have subsets:
WEST consist of Area1, Area2
EAST consist of Area3, Area4
SOUTH consist of Area5
-------------------------------------------------#
how can i related DEPT dimension such as West into subset WEST inside dimension REG using picklist?
any idea?

thanks

[Wim Gielis]

Hello,

A picklist attribute on the dimension DEPT could be a possibility.
Then put the values subset:REG:West, subset:REG:East, subset:REG:South on the respective elements.
This could be sufficient but I don't know if you have other elements to populate.

Alternatively you could create a picklist cube, containing this as a rule:

Code: Select all

[{'West','East','South'}] = S: 'subset:REG:' | !DEPT;

Of course, in both cases, you see hardcoded regions.
You might want to change that a little bit, or not, see what you think is best given your elements / dimensions.

[artikh]

Hello,

A picklist attribute on the dimension DEPT could be a possibility.
Then put the values subset:REG:West, subset:REG:East, subset:REG:South on the respective elements.
This could be sufficient but I don't know if you have other elements to populate.

Alternatively you could create a picklist cube, containing this as a rule:

Code: Select all

[{'West','East','South'}] = S: 'subset:REG:' | !DEPT;

Of course, in both cases, you see hardcoded regions.
You might want to change that a little bit, or not, see what you think is best given your elements / dimensions.

Hi Wim,

thank you for the advance. i've did your steps, and the result is pick list appear in other element of dimension. such as;
dimension:Measure
element:Amount

its quite funny i though. cause, the Amount attribute is null and there's no formulas or anything related to it.

[Wim Gielis]

As indicated, you could create a picklist cube, containing a rule as shown.
In that rule, you could limit the measures dimension elements to 1 element - if needed - such that amount does not show the picklist.