refer to an entity member within a Rule

I have a Rule built for a P&L however certain accounts within the P&L want to look up to certain cost centres.

An example would be Print and Paper looking at the cost center for marketing:

I have put in the rule next to the entity Print and Paper {Cost Centre = MAR} however I am getting zero as a value. Am I doing this correct? With MAR being the code and description for the given cost centre. There is data to display however it does not show that which is expected.

Find more posts tagged with

Accepted answers

All comments

Leone Scaburri

Dear Jack Footer,

it seems you want to use Data picker functionality: https://community.board.com/docs/DOC-1197-board-data-picker-functionality

You have to specify Cube name, the syntax of the Data Picker is the following:

@[CubePhisicalName]{Entity1Name=Member1Code,Member2Code;Entity2Name=Member1Code…}

Regards,

Leone

Jack Footer

Even if the cube name is the cube I am applying the Rule on?

Leone Scaburri

Yes, even if the cube name is the cube you are applying the Rule on.

Jack Footer

Do I need to also list out the member in which the block is applied to ie. {Account=Print and Paper}