Hello,
I have done the below steps:
1. Created the Smart data access connection from BW on HANA to ERP on HANA (Hana Live)
2. Created Source system in RSA1 (One logical system per schema) to ERP
3. Created test table in BW system
4. Created the InfoProvider (open ODS view) using source system defined
Now when I am trying to view data of the InfoProvider (OpenODS View), i am getting the privelege issue:
C *** ERROR => EXECUTE on connection 0, rc=2048
[dbslsdb.cpp 3598]
C SQLCODE : 2048
C SQLERRTEXT : column store error: fail to create scenario: [2950] user is not authorized
C SQL COMMAND: CREATE CALCULATION SCENARIO "0BW:BIA:OODSTEST" USING '<?xml version="1.0" encoding="utf-8" ?><cubeSc\
C hema version="3" operation="createCalculationScenario" defaultLanguage="EN" defaultSchema="SAPBIH" c\
C reator="BW"><calculationScenario name="0BW:BIA:OODSTEST"><scenarioHints createInMemoryOnly="false"><\
C parameter key="doReverseReplaceAll" value="true"/><parameter key="doScenarioValidation" value="false\
C "/></scenarioHints><dataSources><tableDataSource name="MAIN" schema="DEMO" table="TTEST"><attributes\
C ><allAttribute /></attributes></tableDataSource></dataSources><calculationViews><aggregation name="A\
C GGR" defaultViewFlag="true"><keyfigures><keyfigure name="__numoffacttablerows" datatype="fixed" leng\
C th="17" scale="0" aggregationType="COUNT"/><keyfigure name="VALUE1" datatype="fixed" length="18" sca\
C le="0" aggregationType="SUM"/><keyfigure name="VALUE2" datatype="fixed" length="18" scale="0" aggreg\
C ationType="SUM"/></keyfigures><viewAttributes><viewAttribute name="ID1_KEY" datatype="fixed" length=\
C "18" scale="0"/></viewAttributes><inputs><input name="MAIN"><mapping target="ID1_KEY" source="ID1"/>\
C <mapping target="VALUE1" source="VALUE1"/><mapping target="VALUE2" source="VALUE2"/></input></inputs\
C ></aggregation></calculationViews></calculationScenario></cubeSchema>' WITH PARAMETERS ('EXPOSE_NODE\
C ' = ('AGGR', '' , '0BW:BIA:OODSTEST.AGGR', '0'),'EXPOSE_NODE' = ('AGGR', '' , '0BW:BIA:OODSTEST', '0\
C '),'INMEMORY_SCENARIO'='false') ;
B ***LOG BY2=> sql error 2048 performing EXE [dbds 618]
B ***LOG BY0=> column store error: fail to create scenario: [2950] user is not authorized [dbds 618]
C
C *** ERROR => PREPARE C_0202 on connection 0, rc=258
[dbslsdb.cpp 9139]
C SQLCODE : 258
C SQLERRTEXT : insufficient privilege: Not authorized
C sc_p=0000000007ABD450,no=202,idc_p=0000000000000000,con=0,act=0,slen=111,smax=2304,#vars=0,stmt=00000000497C5B70,table=
C SELECT "VALUE1" AS "K____7604", "VALUE2" AS "K____7605" FROM "DEMO"."TTEST" AS TAB GROUP BY "VALUE1"\
C ,"VALUE2" ;
B ***LOG BY2=> sql error 258 performing OPC [dbds 437]
B ***LOG BY0=> insufficient privilege: Not authorized [dbds 437]
A ***SUBPOOL*** generating subroutine pool %_T0007K for user SAP* (07ee0003).
Can you please help to resolve.
Regards,
Saurabh