Issue with cascading prompt.

building reports webintelligence
1

Hi,

I have a universe with row level security and cascading prompt implemented.
When I run a report using this universe I get the following issue.

  1. When I run report with default *(For all) it works fine. But when I select any values from the cascading prompt it does not display any record
  2. When I remove the security from universe, report works fine.
  3. When I run the report without any prompt and security implemented, it works fine.

All the above issue is only when I run the report in view mode. There is no such issue when I run the same report in modify mode. I do not get any error message on the screen but I can see “The report is not refreshed” at the place of Refresh Date(Bottom right of the report design window)

Any help is appreciated.
Thanks
 

amrendra83 (BOB member since 2010-05-03)

2
  1. Its because you may be getting only those values which is set in row level security. But while selecting individual values, it may be getting filtered out due to row level restriction
  2. Obviously it will
  3. Yes thats right, since there are no exclusive conditions other than row level (where clause)
    Not sure how its working in view mode, it depends on coupe of things like the account being used and the way report is designed. You should be specific here on how the report is designed and run
    .

haider :es: (BOB member since 2005-07-18)

3

Hi Haider,

Thanks for the reply.

While selecting values in prompt it should return some data even if we have row level security. With the same prompt selection and security implemented, the report return data in modify mode.

Regarding the report design and run process, the report has designed in InfoView and it is a list report that have only four fields and cascading prompt (Region>Country>City). I am running the report from InfoView itself.

The point here to be noted is I am getting “Data is not refreshed” at the place of Refresh Date(Bottom right of the report design window).
If the report query do not return any data it should pop up message like “Query1 does not rutnrn any data” but i do not get any thing on the report screen except the report structure.

Thanks,
Amrendra

amrendra83 (BOB member since 2010-05-03)

4

May or may not return values, depends on what account being used and the security defined for it

Again the account logged into to Infoview comes into play

You have to tell the exact workflow followed while displaying prompt values or working in edit report mode, are you fetching prompt values in Designerwith one account and using another account in Infoview while in modify mode
.

haider :es: (BOB member since 2005-07-18)

5

Hi Haider,

After a lot of analysis on the report i found that row level security was not implemented on the universe when i was creating the report. After the report creation i applied the row level security on universe. After the security implemention on universe the issue started with report.

Now i have row level security on the universe and i created the exact report using the same universe. When i run this report i do not get any issue.
Does the security implemetion on universe after/before the report creation matter?

Thanks
Amrendra

amrendra83 (BOB member since 2010-05-03)

6

No, it shouldnt matter even if there are existing reports pointing to this universe.
But the reason for you to have issue might be either due to the universe not being exported properly with the security or the reports not picking changes
.

haider :es: (BOB member since 2005-07-18)