cancel
Showing results for 
Search instead for 
Did you mean: 

Worksheet logic

Former Member
0 Kudos

Hi,

Can any one give me an example of worksheet logic? Also, can anyone give me the links which explains the same.

Regards,

Diksha

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Diksha,

Any calculation done on the BPC excel can be termed as worksheet logic. For example, fetching data through EVGTS, or doing some mathematical calculations using native excel formulas.

Worksheet logic includes the functions provided by BPC, plus the native functions of Excel itself.

Any functions relative to BPC excel can be found in the below link:

http://help.sap.com/saphelp_bpc75/helpdata/en/5A/69200C88AA40C9B18844A25259F147/frameset.htm

And then go to "functions reference".

Hope this helps.

Answers (1)

Answers (1)

Former Member
0 Kudos

There isn't a link to any specific guidance on Worksheet logic. BPC for MS has always broken LOGIC down to 3 buckets, Script - Which is calculated on the base members, DIMENSION - Defined in the Member sheet and may calculate on all levels of a cube using statements like, 'Iif(NetRev = 0, Null, NetIncome / NetRev) * 100, Solve_Order=10, and then Worksheet. Worksheet logic is just any modeling that you perform outside the core claculation engine or DB, in excel, where the INPUTS and OUTPUTS are sent to the cube and stored for future recall.

Hope this helps.