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.
Answers
-
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
0 -
Even if the cube name is the cube I am applying the Rule on?
0 -
Yes, even if the cube name is the cube you are applying the Rule on.
0 -
Do I need to also list out the member in which the block is applied to ie. {Account=Print and Paper}
0
