Hi
I have two reports A and B with the two selection years [one for Actual(ContextMember) and other for Plan(Selectmember) and they are working fine. Using EPMPathLink, i want to execute the report B from Report A for the same selection years.. The...
Hello,
Using RSDDB, I have created an analytic view for queries as Infoprovider in SAP HANA database. The Analytic view is not getting refreshed, I have daily deltas going into the source of the Bex query. Am i missing anything else.
Thanks!
Ye...
Hi
We are in HANA 2.0 and trying to create a dynamic analytic privilege(Repository using .HDB procedure) on an information view base on a table which has a user id and compcode.
The .hdb procedure returns the list of values for the respective ses...
Hi Jing She, I get the below error when I go for select*from _SYS_BIC.sap.ZZZ/AN_EXPENSESAP DBTech JDBC: [258]: insufficient privilege: Could not obtain all relevant analytical privileges for user xyz accessing view ._SYS_BIC.sap.PCM/AN_EXPENSE due t...
Hi Jin Shen, Thanks for your input. Please find the below changes.(instead of compcode, iam using PCMAFFILIATE)PROCEDURE "PCM"."sap.PCM::TEST_SP2" (OUT OUT_FILTER VARCHAR(5000))
LANGUAGE SQLSCRIPT
SQL SECURITY DEFINER READS SQL DATA AS
v_Filter VAR...
Hi Shen,Please find the below code and advise accordingly. Thanks!create type "PCM"."TT_AFFILIATE_ID" AS TABLE ("PCMAFFILIATE" nvarchar(256));create column table "PCM"."AUTH_INFO" ( "PCMAFFILIATE" NVARCHAR (256) PRIMARY KEY NOT NULL,
"User_ID" VARCHA...
