on 12-28-2011 4:56 AM
Hi All,
We have dimensions for Cost Center and Company code in one of our BPC Applications..Is there a way we can avoid users planning for incorrect combinations?
E.g. -
Valid Combinations -
Cost Center 1 >>>Company Code 1000
Cost Center 2 >>>Company Code 2000
In case the user selects Cost Center 1 & Company code 2000 in current view and enters plan values - the system should not allow the same...Is there a way to maintain valid combinations for dimension members (belonging to different dimensions) in BPC???
Hi Shibu,
Maybe you can try this. Put in Cost Center dimension, a new properties name CompanyCode.
Put in every cost center, the company code.
The easiest way when you create the input template is :
1. The Company Code and Cost Center in Page axis.
2. The user only select the cost center.
3. Use EVPRO syntax to get Company Code for every Cost Center is selected.
4. Put the value Company Code automatically ( use cell reference ).
Hope it helps.
Thanks,
suprapto
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi All,
Using this method you can describe only one to many relationship between CompanyCode and CostCenter. "Many" side is where you define and fill property.
Theoretically, you can enter comma separated list of members in the property and get this list using EVPRO, but what you will do with this list?
B.R. Vadim
Hi Uemerson,
It works: I put the comma separated list in the property (ensure that the size of the property field is enough to store the list). And I was able to get this property using:
=EVPRO("APPNAME","MEMBERID","PROPERTYNAME")
In the cell with the formula I can see the comma separated list stored in the property. But comma separated lists can be only used in PageRange of the read only report to get figures automatically summed for the members of this list.
About your primary goal: one to many relationship will work OK.
Vadim
I have the same problem, anyone knows what´s the most simple solution?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shibu,
You can maintain a COSTC property for the Company Code dimension.
So, when the user selects cost center 1 or 2, then the template should display only those company codes, for which the COSTC porperty is either 1 or 2.
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thank you for your response. We tried this approach and the same does not work for us...
The relevant details are as follows -
P_COMPANY is the Company Code Dimension
P_COSTCTR is the Cost Center Dimension
A cost center is assigned to exactly one company code. A company code has multiple cost centers under it..
We created a Property called 'P_COMPANY' in the P_COSTCTR Dimension. For each cost center we maintained the relevant company code in this property...
We observed that when we select a particular cost center in current view, we can still select any company code.
Please Advise...
Hi Shibu,
In the CV, you will be able to select any cost center or company code. You can not restrict this in any way.
The maximum that can be done is within the template. You need to put the restriction in the memberset options for the P_COSTCTR. So that, when the user selects a particular member for the P_COMPANY dimension, the template will display only those members of P_COSTCTR for which P_COMPANY is set to the selected company code.
Hope this helps.
Hi Shibu,
Let me try to give an example.
Lets say you have P_COMPANY and P_COSTCTR in row expansion. Maintain a member for P_COMPANY dimension in its memberset options. In the memberset for P_COSTCTR, you can have:
PROPNAME = B28
Assuming B28 is the memberset option for P_COMPANY dimension.
Hope this helps.
Hi Shibu,
It was just an example, to show you how to control the combinations. You might have to design it based on the exact business requirement.
Please note that this wont be a straight-forward process, and you might have to use some VB macros to ensure you get, what you require.
Lets say, based on the expansion, you have 5 company codes to be displayed in the template. You should, first, use an EVEXP function to list all the 5 company codes in some empty region of the template. Use a macro to concatenate all the 5 company codes separated by "|". Then, for the expansion on cost centers, you should again use a macro which will consider each of the 5 company codes at a time, and set the expansion to "P_COMPANY = ABC". Since you have 5 company codes, hence you will have 5 such combinations of member filter pertaining to each of the 5 company codes. Then you must concatenate them using "|", and this should be the memberset option for the cost center dimension.
I understand that this is going to be a bit complex, but I dont see any other option.
Hope this helps.
User | Count |
---|---|
15 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.