Error while activating Calculation View

[Former Member]

Hi,

I am trying to activate a very simple calculation view (using sql script) but it is failing with column store error - 34053. I tried different tables and schemas but still get the same error.

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

MDXRuntime: Internal deployment of object failed: Internal Error:Deploy Calculation View: SQL: column store error: [34053] failed to save calculation scenario : The following errors occured: Could not create repository entry for scenario (34053)nDetails (Warnings):n- CalculationNode (139206) -> attributes: No attributes found.nnnSet Schema DDL statement: set schema "EFashion"nType DDL: create type "_SYS_BIC"."efashion/CV_SCRIPT/proc/tabletype/VAR_OUT" as table ("ARTICLE_ID" INTEGER, "COLOR_CODE" INTEGER)nProcedure DDL: create procedure "_SYS_BIC"."efashion/CV_SCRIPT/proc" ( OUT var_out "_SYS_BIC"."efashion/CV_SCRIPT/proc/tabletype/VAR_OUT" ) language sqlscript sql security definer reads sql data as  n /********* Begin Procedure Script ************/ n BEGIN n t var_out = SELECT article_id, color_code t          FROM shop_facts;nnEND /********* End Procedure Script ************/nVersion: 62n

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

I'll appreciate any inputs on this.

Regards,

Vimal

[Former Member]

Hi Vimal,

From the limited information available here, recommed you to check check the following:

a. In your var_out, you have declared both article_id and color_code as integers. Are they defined as integers in the underlying table as well?

b. The error message that stands out is "No attribtues found". In the output part of your calculation view, have you added any fields to the output section on the right side? Have you added them both as attribtues or both as measures?

In revision 35 (that I am currently on), it allows you to have calculation views with just attributes and no measures and vice versa. However, not sure if this was the case in previous revisions.

c. If you are on an older revision, suggest you upgrade to one of the later or the latest revision.

Thanks,

Anooj

[Former Member]

Hi Anooj,

a. Both are defined as integers in the underlying table as well.

b. I've defined article_id as an attribute and color_code as a measure.

c. If this continues then we'll upgrade to revision 35. I am currently using AWS image, which is on revision 28.

As I've mentioned earlier, this looks like some kind of an access issue. If i take the resulting procedure from the error message and var_out type and try to run it through SQL Editor then still i get the same error. BTW I'm using user SYSTEM so assuming that it should have all the access and I've granted select access on underlying schema to _SYS_REPO user. Not sure if I need to define any other access.

Regards,

Vimal Shah

[Former Member]

Ok, are you able to activate attribute & analytical views successfully?

[Former Member]

Just to add - you might know this already - revision 35 for AWS is now available

[Former Member]

Yes, I am able to activate attribute and analytical views successfully. Also, i saw documenation on how to upgrade aws version to revision 35 so as a last resort i will do that.

[rama_shankar3]

Vimal:

Upgrading to revision 35 only takes few minutes if you follow the instructions mentioned in the below post instructions or watch the video.

http://scn.sap.com/docs/DOC-30980

  I suggest you upgrade to eliminate the doubt.

Regards,

Rama