on 02-22-2017 10:38 AM
Hello,
I want to add a simple formula to some dimensions members.
In BPC Standard I had the following:
Member A from dimension DIM1 has a property, FORMULAH2, which have this value: [DIM1].[H2].[B], that is, it takes the value from B.
How can I create this formula in BPC Embedded?
Thanks in advance.
Hi Christina,
As per this blog by Gregor....
https://blogs.sap.com/2014/10/21/concepts-compared-bpc-standard-and-bpc-embedded/ Section 3.2
"The most important and fundamental difference is that in ‘BPC standard’ one can have ‘base members’ in a dimension and also calculated members, e.g. account C = account A + account B. This is never ever possible in ‘BPC embedded’, by definition any dimension member is base member and there don’t exist calculated dimension members. This comes from the design of the reporting engines, in ‘BPC standard’ this is an MDX engine and in ‘BPC embedded’ the BW Analytical Engine based on BW queries. In ‘BPC embedded’ this kind computations can be modeled as part of the BW query using the BW Query Designer. "
You will have to individually apply formulas to each member at the BEX Query level, as per my knowledge...
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
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.