setDimensionFilter using hierarchy node

[former_member417140]

Hi,

I´m trying to filter a data source in a SAC application using setDimensionFilter. I´ve successfuly done it in the past using a normal dimension (filtering a member, no hierarchy used). I´m trying to filter now using a node of a hierarchy but it doesn't work. The hierarchy is imported from BW in an acquired data model.

Dimention ID: "Profit_Cent_1x5ly5c5z5"

ID of the node to be filtered:"X0012016_BPAO"

Hierarchy ID: "Profit_CenterPARENT" (this is automatically generated when you import the data from BW)

If tried a few options:

DS_1.setDimensionFilter("Profit_Cent_1x5ly5c5z5",["X0012016_BPAO"]);

DS_1.setDimensionFilter("Profit_Cent_1x5ly5c5z5-ProfitCenter-PARENT",["X0012016_BPAO"]);

......

Any idea if this can be done and what is the correct syntax?

Thanks

[former_member542603]

Hi,

It depends on how the Hierarchy is Created.

For Example i have the Dimension "State " created based on "State" and "Country".

My Filter will look like "SetDimensionFilter("State","[State].[Country].&[Nairobi]");"

Nairobi is the value to be applied as filter.

To find the exact format,

- Create table in the application. On Select "Var Selection=Table_1.GetSelections()"

- Run with Developer Console on

- Put a break on Select. You will see the exact format on the variable selection.

You can use this format to apply filter on the table.

- Sathya