on 2016 Apr 12 8:57 AM
Experts,
We are on BW 7.5, HANA SP11.
I have a calculation view based on a generated analytic view from a BW cube.
When I try to use currency conversion in HANA calculation view, the "schema for currency conversion" does not show the BW schema i.e SAP"SID" to use the TCUR* tables. Is it an authorization issue? How can I use the BW TCUR* table to perform currency conversion in HANA?
Any hints is well appreciated.
Thanks and Regards,
Srinivas
Hi Srinivas,
1. Please Confirm, BW Schema name is SAP<SID>.
Because It is possible to configure BW schema with other Names as well.
(In my all systems, BW Schema Name is SAP<SID>.
But one of my system, BW schema Name configured as "SAPABAP1")
2. If your schema name configured as SAP<SID>, Then your HANA DB user might not have privilege for this schema. Please check SAP<SID> is shown under catalog node.
If User does not have privilege for this Schema, Object Privilege has to be assigned.
3. One more Option which will be used in Side car scenario is,
Using Data Provisioning Tools (SLT/BODS), Replicate TCUR* Tables
to User created schema of Target HANA system from Source ECC system.
User defined schema has to be mentioned as Schema for Currency Conversion
Regards,
Muthuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for your feedback.
1. Yes I confirm BW schema is SAP<SID>.
2. BW schema is not visible in the catalog node either. However, I can access the BW tables such as DSO's, and other BW tables including the currency tables in various Attribute and Calculation views.
BW is our business warehouse system to which the currency tables are updated from various source systems. We would like to use these currency tables in HANA views to perform the currency conversion.
Regards,
Srinivas
Hi Srinivas,
Please try this.
1. Choose Schema Mapping, In Schema Mapping Pop-up,
Mention "SAP_TEST" As Authoring Schema and Select SAP<SID> Schema as Physical Schema.
2. Then Open Your Calculation View, Mention Schema for Currency Conversion as "SAP_TEST" and Try to create Currency conversion Calculated Measure.
I hope it would work.
Regards,
Muthuram
Hi,
In HANA SQL console executing the below query gives 'SAP DBTech JDBC: [258]: insufficient privilege: Not authorized'
select * from "SAP<SID>".tcurr
However, when I use the same table 'TCURR' taken from 'SAP<SID>' schema in an Attribute / Calculation View, I can preview the data of this table.
Thanks
Srinivas
I am not sure why that happens. Cant remember if I came across this scenario of not having select privilege on table but was able to access view a modelling view.
Anyway, we now know that you do not have access to the BW schema. As a BW developer you would definitely need that. You may have to get the access and then use it as the default schema in your view.
The systems that I worked with, developers generally have access to all schema's(SELECT) except for some system schema. Just like you do not restrict developers with infoarea or object level access in a BW system, it is not a good idea to restrict developer access to BW and ECC schemas.
Dont forget to update and close the discussion if you have your solution.
User | Count |
---|---|
79 | |
11 | |
10 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.