Skip to Content
avatar image
Former Member

SQL BPC 10.0 Netweaver(NW) Syntax


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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 12, 2014 at 04:37 AM

    Hi Christopher ,


    What do you mean by "SQL" syntax??


    Vadim

    Add comment
    10|10000 characters needed characters exceeded

    • 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!

  • Sep 12, 2014 at 04:57 AM
    Add comment
    10|10000 characters needed characters exceeded

    • 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

      Capture.PNG (17.3 kB)