on 06-07-2013 3:56 AM
hi bpc gurus:
I m building 3 input forms on a single sheet, like this:
But I have a doubt on how to build the Input Form "Cost", since every cell of this input form is calculated by multiplying input form "Sell" and input form "Rule" (the user doesnt have to input anything in input form "Cost", BPC must calculate every cell). How can I achieve this? Obviously when the user press "Save Data", BPC must save the data of the 3 input forms.
is there some way to achieve this?
PS: the number of rows of these 3 input forms is the same, they can change based on the context values which affect the 3 input forms.
regards
jav
Hi Jav,
You can use EPMCopyRange() Function for Input Form "Cost". In function give the report id, range.It will apply both formatting and formula to the whole report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jav,
1) You can write script logic in Default to calculate the Cost.
[Dimension].[COST] = [Dimension].[SELL] * [Dimension].[RULE]
if you want the Cost values to be saved in Database. This logic will calculate Cost automaticaly whenever you save the Sell or Rule.
2) You can write dimension member formula for Cost
[Dimension].[SELL] * [Dimension].[RULE]
This will be calculated at runtime.
3) if you are using BPC 10 , you can use Local Member Formula for the same.
Best Regards
Obaid
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jav,
But why don't use script logic in the default.lgf to perform this calculation?
B.R. Vadim
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
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.