BI 7.0 Security--Hard-coded Queries are not working.

[Former Member]

Hi Folks.

We have implemented BI 7.0 system recently.

We designed Finance reports for CEO and it is working fine. CEO is having access to comany codes 1000,2000,3000.

Now CEO want to assign same query (report) to Vice president but with access to only company code 1000.

Testing details:

Comany codes : 1000,2000,3000.

User : test_vp

pfcg role : test_fico

rsecadmin role : test_rsec_fico

I gave in rsecadmin test_rsec_fico role "0comany_code=1000". But while executing query, it is showing as no authorization for comany code 2000 & 3000.

I know its hard-coded query and BI developer dont want to remove hard-coding.

So is any way to resolve this issue?

Regards

Imran

[Former Member]

So, the report has the ability to do whatever it does only if the user is authorized for all three companies, regardless of which they restricted their selection for?

Have you restricted the selection to '1000' only and check whether it might work that way?

Otherwise, you could copy the report and then remove / change the hard-coded authority-check, but you would then need to hard-code that only data from company '1000' is displayed or can be selected.

If it is really hard-coded org values to even run the report, then that is what you get for it. Perhaps your developer is trying to create work for themselves.

[manohar_kappala2]

Hi,

When you say hard coded are you referring to the variable attached to the query restricted to comp codes 1000, 2000, 3000. If so then per design this means that the query is supposed to run for these three company codes and once u restricted access in the back ground for one of these three comp codes u will not be able to see the report output as the query selection checks for all 3 comp codes and not 1000 alone. Try changing the variable type as authorization in this way the user will be able to run the query for what compcodes his user profile contains authorizations too.. But yes in this option too you would need to modify variable attached to the query.

[Former Member]

closed.