Skip to Content
author's profile photo Former Member
Former Member

Writing Alias column using select query in Calc View using CE functions

Hi All

I am trying to derive a new column out of exisiting columns by using select query on CE function CE_CALC_VIEW as mentioned below

BEGIN

var_out =CE_CALC_VIEW("_SYS_BIC"."zhanajlr/CRM_JLR_CE_VISIT_CALCVIEW",["NAME_FIRST",

"PARTNER","TELNR_LONG","NAME_LAST","SMTP_ADDR","CITY1","COUNTRY",

"DESIGNATIONTEXT","INDUSTRYTEXT","AGE_GROUP","VISITID","VISITDATE",

"VISITPRODUCT","PRODUCTTYPE","PRODUCTMODEL","VISITTYPE","PRICE",

select count(VISITID) group by VISITPRODUCT as "VISITCOUNT"]);

END

but I am facing error as below incorrect syntax near "select": line 8 col 1 (at pos 559)nSet Schema DDL statement: set schema Type DDL:

can we achieve same using calculated attributes or I am missing any syntax , request suggetions in solving the problem.

Thanks

Santosh

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jun 04, 2012 at 08:14 AM

    I think you need to use CE_AGGREGATION function

    Can you please try with CE_AGGREGATION ("_SYS_BIC"."zhanajlr/CRM_JLR_CE_VISIT_CALCVIEW", [count("VISITID" AS "VISITCOUNT"], ["VISITPRODUCT"]);

    Please refer to page 30 of the SQL script manual for details.

    Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Ravindra Channe

      Hi Ravi

      Yes , I agree with you ,Hope there would be more functionalities supporting with CE functions,otherwise we can't get the whole advantage I believe,because in real-time most of the requirements would be complex.

      Thanks for patiently answering my questions,may be some questions look silly .

      Thanks

      Santosh Varada

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.