SQL BPC 10.0 Netweaver(NW) Syntax

[Former Member]

Where is the guide that contains the SQL syntax for BPC 10.0 Netweaver?  I want to learn the proprietary SQL code to write Script Logic in BPC.  Where are the resources?

[former_member200327]

Try Logic Keyword Reference - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP L... and follow references.

[Former Member]

Hi Gersh, Thanks for the response.  I'm reading through the information at the link you provided. I noticed at the bottom of the page they refer to

Enterprise Performance Management (EPM) How-to Guides - Business Process Expert - SCN Wiki

At the wiki, the only logic it speaks of is 5.x.

1. Where is the advanced guide to FULL syntax?  The samples I see are basic and I don't think ALL possibilities are outlined.

As an example.  When I go to *WHEN / *ENDWHEN - SAP Business Planning and Consolidation, version for SAP NetWeaver - SAP Library

It says "A  WHEN /  ENDWHEN structure works in the same way as the  SELECTCASE /  ENDSELECT structure, with  *REC( ) statements that generate new records. The syntax is the following:" 

2. Where is SELECTCASE/ ENDSELECT defined?

3. Maybe the source you have cited is the ultimate go to guide?

Thank you again.

[former_member186338]

Hi Christopher,

I do not recommend you reading the mentioned in your post outdated and incorrect guides...

Use only help, but even in help you will see a lot of mistakes.

"Where is SELECTCASE/ ENDSELECT defined?" - in the same place in help you will see the definition. But it's MDX logic, not recommended.

You will not find a better guide

B.R. Vadim

[former_member200327]

Hi Christopher,

If you have patience to scroll further down that Wiki page you can find a lot of How To ... Guides for 7.5, 10.0 and even HANA. Please check White paper Script Logic Primer by Sheldon Edelstein.

If you click on SELECT/ENDSELECT on page I sent you it will bring you to syntax of that clause.

Regards,

Gersh

[former_member186338]

Hi Christopher ,

What do you mean by "SQL" syntax??

Vadim

[Former Member]

Hi Vadim, Thank you for asking. Referring to the information below, where is the book on "our proprietary language"?

See the image below which is from the document located here:  http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b0962ac4-3361-2b10-40bf-dc274fe38...

1. "Always go with SQL logic"

2. "SQL Logic is NOT Microsoft but our proprietary language"

[former_member186338]

Ups, I will try to explain this common misunderstanding:

1. You can write script using MDX formulas like:

[P_ACCT].[#CE0661000]=[P_ACCT].[CE0004010] + [P_ACCT].[CE0004020]

In most cases the calculations with MDX syntax are very slow!

2. You can avoid MDX and use so called "SQL" syntax (nothing common with SQL language):

*WHEN P_ACCT

*IS CE0004010

*REC(EXPRESSION=%VALUE%+[P_ACCT].[CE0004020],P_ACCT=CE0661000)

*ENDWHEN

So basically WHEN/IS/REC/ENDWHEN - is the "SQL" syntax! Much faster then MDX.

Vadim

[former_member186338]

P.S. Commands like:

*XDIM_...

*FOR… *NEXT

*INCLUDE

...

Are used for both SQL and MDX.

In the other words syntax is the syntax of writing data to the cube!

Vadim

P.S. Use COMMIT ONLY with MDX syntax, for "SQL" it's useless!