EPM democontent calculation view throws error

[Former Member]

I'm using the new SPS6 trial on Cloudshare. The new environment comes with the EPM demo preimported.
I'm trying to run some analysis on the predefined calculation view CV_SALES_OVERVIEW in sap.hana.democontent.epm.models, however, I keep getting errors.
If I use the Data Preview-function in HANA Studio (just dragging any object to an axis), I get the following error:

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [2620] executor: plan operation failed;currency/unit conversion error,could not read currency precisions from table "SAP_HANA_EPM_DEMO"."TCURX" - invalid table name:  Could not find table/view TCURX in schema SAP_HANA_EPM_DEMO: line 1 col 53 (at pos 52) at ptime/query/catalog/catalog.cc:4760

TCURX exists, so I can't see the problem... maybe the namespace of the table, but there is no field in the currency conversion dialogue to specify a namespace.

Any ideas? Or anyone who can reproduce the problem?

Thanks in advance!

[Former Member · Accepted solution]

Hi Andreas,

I just tried this out, you might need to recreate the synonyms.

Here's how :

1. Go to

http://<myServer>:<XS Port>/sap/hana/democontent/epm/admin/ui/WebContent/

admin.html

2. Check Create Synonyms and Click Execute.

OR

Create synonyms from HANA Studio.

Check if data preview on CV_SALES_OVERVIEW works after this.

I'm sure the experts can provide a better way.

Let me know if this works!

BR,

Nidhi

[thomas_jung · Accepted solution]

One prerequisite is the Synonyms as suggested. The other is to maintain a client in your user account. Set the Session Client to 001 in your database user.

[Former Member · Accepted solution]

Nidhi, Thomas,

Thanks for your help. That indeed solved the problem.

Regards,

Andreas

[Former Member · Accepted solution]

Hi Thomas,

Please let me know what would be the server in case of 30day free trial version

1. Go to

http://<myServer>:<XS Port>/sap/hana/democontent/epm/admin/ui/WebContent/

admin.html

2. Check Create Synonyms and Click Execute.

I am facing the same problem

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [2620] executor: plan operation failed;currency/unit conversion error,could not read currency precisions from table "SAP_HANA_EPM_DEMO"."TCURX" - invalid table name:  Could not find table/view TCURX in schema SAP_HANA_EPM_DEMO: line 1 col 53 (at pos 52) at ptime/query/catalog/catalog.cc:4760.

will wait for your update.

THANKS IN ADVANCE,

RK

[thomas_jung · Accepted solution]

Yes that error would come if you haven't generated the Synonyms.  You are asking what your server name is?  I can't know your server name.  You would have to look that up on your system.  For instance look in the HANA Studio at your system connection and see what server name it is using.

[Former Member · Accepted solution]

Thanks Thomas. I appreciated the quick response.

I am using demo provided on the free SAP HANA 30-Day Trial SPS6 No.1 on  cloud share and trying to run some analysis on the predefined calculation view CV_SALES_OVERVIEW in sap.hana.democontent.epm.models,

out of the following two steps provided as a solution for the issue:

Step 1. Go to

http://<myServer>:<XS Port>/sap/hana/democontent/epm/admin/ui/WebContent/

admin.html

result:

I could see the SAP XSEngine for the url:

http://<myServer>:<XS Port>

but a blank page is displayed if I go to

http://<myServer>:<XS Port>/sap/hana/democontent/epm/admin/ui/WebContent/

admin.html

couldn't try Step 2. Check Create Synonyms and Click Execute.

Please share any information/link providing the details on the steps.

Thanks in advance,

[thomas_jung · Accepted solution]

Make sure that you have UI5 installed correct.  There was a problem specific to CloudShare images where the UI5 libraries weren't installed.  Check other threads in the forums on this specific issue for details.  Otherwise use the Chrome Developer Tools to see what libraries aren't loading or what JavaScript errors you are receiving. However most likely seems like the missing UI5.

[Former Member · Accepted solution]

Thanks Thomas. Appreciated your time.

[Former Member · Accepted solution]

Hi Thomas,

Good morning,

I was trying to import the SAP HANA DEMO MODEL 1.0 DU, from the file/import using SYSTEM user. encountered the 'Insufficient privileges to perform import server operation' Please let me know if I need to add any role to this user for importing the DU.

I am new to HANA and may be missing something for import.

Thanks,

[Former Member · Accepted solution]

Hi, I could find a resolution to the issue. I will comeback to you for help if needed in future,

Thanks,

[Former Member · Accepted solution]

Hi Nidhi,

I am seeing a blank page when

1. Go to

http://<myServer>:<XS Port>/sap/hana/democontent/epm/admin/ui/WebContent/

admin.html

Have imported the UI5 TGZ from content and still the problem persists. Please guide me on the probable resolution if you have any.

Best Regards,

[Former Member · Accepted solution]

Hi Krishna,

You can also create synonyms using the foll. statement :

create synonym <target_schema_name>.<synonym> FOR "<source_schema_name>"."<package_path>::<table_name>";

Best,

Nidhi

[Former Member · Accepted solution]

Hi Nidhi,

Thanks for the command above. I have two small questions to ask, if you can please.

1. Is this something that occurs because of the way in which the solution is packaged?

2. How did you figure out that this was the way to fix it? Is it documented somewhere?

Regards,

Manish