BI Variable authorization issue

[Former Member]

Hello Experts,

Please help me with the below issue. I have implemented Variable authorizations as below.

1)I have marked Cost Center and Profit Center info objects as Auth relevant.

2) Created a global Variables for CC and PC with processing by authorization & user exit.

3) Created analysis authorization for the info object 0cost center and Profit Center and added value as $ ZCOST.

4) Created the include program ZSECTEST in the user exit to check the Variables.

I have created only one analysis authorization with both CC and PC fields and restricted to Variables.

Scenario 1: If the Query that was built on the Cube has only CC data authorizations are working fine by picking the values from the table. u2013 Working

Scenario 2 : I have a query that was created on MP which has cube A with CC and cube B with PC data.

(system checks if the user has access both info objects since both were auth relevant fields)

When user ran the query u2013 custom code checks the table and gets the CC and PC values to the query variable screen.

Issue: If the query has both CC and PC data for the given date it was showing results fine.

If the query has only CC data and no PC data then query is giving message saying no data available.

My requirement is even there is not PC data for that date I want to display the CC data.

Thanks in Advance.

Thanks,

Kumar.

[Former Member]

If the query has only CC data and no PC data then query is giving message saying no data available.

Can you check if the table storing the CC and PC data has PC defined as the Primary key. In that case a NULL value for PC would not return any output (not even the CC data)?

Thanks

Sandipan

[Former Member]

Hello Sandipan,

Thanks for the quick response. Primary key has been already defined in the table. Issue is I have only one analysis authorization created with fileds CC and PC restrcited to variables VAR1 and VAR2 respectively.

When I execute the query in the variable selection screen values are coming fine as below from the custom table. (works)

Variable selection screen :

Cost Center - 1,2,3,4

Profit Center - A,S,D,F

Date - 10/2010

In the above example if the query has only CC data for that date - I get error no data available because system is fetching for the combination of CC 1,2,3,4 and PC A,S,D,F . I guess some aggregation auth are missing.

When I execute the same query with SAP_ALL and BI_ALL I get results with only CC - because PC data on this query was not available for that date.

My requirement is even if the PC data was not avaiable for that date I want to display all the CC realted data.

Thanks,

Kumar.