Skip to Content

CE Function : CE_CALC_VIEW - running with placeholders

Hi Experts ,

I am bit stuck in specifying placeholders in a graphical calculation view.

I created one graphical calcualtion view which has 2 mandatory input paramters(PLANT & DATE).

  • How use CE Function to access the cal view with placeholders ?
  • how can i use direct select statement to fetch data from calculation view with dynamic placeholders (I am trying to fetch calculation view inside a procedure)
SELECT  "YYYYMM", 
      "DebitCreditCode",
sum("AmountInCompanyCodeCurrency") AS "Amount" FROM "_SYS_BIC"."TurnOverValue_BugFix/ABCDEFG_L1"
('PLACEHOLDER' = ('$$PLANT$$', '0001'), 'PLACEHOLDER' = ('$$TO_DATE$$', '201401')) 
GROUP BY 
"DebitCreditCode", 
"YYYYMM";

Here, i need to replace '0001' and '201401' with dynamic values. I tried bot ":variable_name' and "variable_name". Both raise error.

Thanks in advance ,

Sreehari V Pillai

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Mar 19, 2014 at 06:56 AM

    any hope ????

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 21, 2014 at 01:07 PM

    Hi Sreehari,

    why you do not create the calculation view in script mode. There you can write SQL:

    SELECT  
         "YYYYMM",  
         "DebitCreditCode",  
         sum("AmountInCompanyCodeCurrency") AS "Amount" 
    FROM "_SYS_BIC".TurnOverValue
    WHERE "PLANT"        = :plant
    AND        "TO_DATE"  =  :date;
    

    Here you only have to create the direct Input Parameters plant and date with corresponding types.

    Is it that, you wanted to know?

    Regards

    Jonas

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Ravindra,

      From your replies to others questions in SDN , i found the sysntax even before, but still facing issues 😔

      Calculation view -- SQL Generated automatically

      Generated SQL: 
      SELECT TOP 200 "DebitCreditCode", "YYYYMM",
      sum("AmountInCompanyCodeCurrency") AS "AmountInCompanyCodeCurrency"
      FROM "_SYS_BIC"."TurnOverValue_BugFix/INVENTORY_TURNOVER_L1"
      ('PLACEHOLDER' = ('$$PLANT$$', '0001'), 'PLACEHOLDER' = ('$$TODATE$$', '201401'))
      GROUP BY "DebitCreditCode", "YYYYMM"
      

      The same is successfully executed and got the output too.

      Procedure ( Got activated successfully )

      But when i am trying to execute the procedure from SQL Console, i am getting the following error.

      call "_SYS_BIC"."TurnOverValue_BugFix/GE_INVENTORY_DATA" ('201401','0001',?);


      Statement 'call "_SYS_BIC"."TurnOverValue_BugFix/GE_INVENTORY_DATA" ('201401','0001',?)'


      successfully prepared



       

      Could not execute 'call "_SYS_BIC"."TurnOverValue_BugFix/GE_INVENTORY_DATA" ('201401','0001',?)' in 246 ms 203 µs .


      SAP DBTech JDBC: [2048]: column store error: [2048] column store error: search table error: [34092] search on calculation model requires parameters;Required variable $$TODATE$$ is not set.Please check lines: 5,

      I am totally confused, and not able to figure out the problem.

      Thanks in advance

      Sreehari

      calc.JPG (26.1 kB)
      proc.JPG (43.6 kB)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.