Pager using a Dynamic Selection & Presentation  = "Authorization issue"

Dear Boardville members,

We updated recently to 10.1.4 (from 10.1.2) and we noticed a bug when adding specific reports to a Presentation.

When the report uses a pager, with a dynamic selection such as "current period" setup in this pager, an error message appears when adding to a presentation. It says something like "Access Denied. You are not authorized to access this database."

If you are using Presentations, did you have any opportunity to test this ? We opened a ticket #40602 but I'm curious to know if we are alone using this kind of features... since it's visibly a regression issue it should have been spotted before ?

Obviously I'm also interested in any kind of workaround to guarantee a correct selection on these screens without displaying an old period by default...

Thanks for your feedback.

Etienne

Find more posts tagged with

Accepted answers

All comments

Alexander Kappes

Dear Etienne CAUSSE,

thanks for your request.

We are Aware of this Problem and send this to our LAB.

In the meantime you can Workaround by upgrading your Database Profiles.

The Problem only occurs for Users according to DB Security Profiles with Access Mode set to "Read" and "Read and Write".

Doing so the Problem is workarounded.

perhaps it helps

regards

Alexander Kappes

Etienne CAUSSE

Hi Alexander Kappes

Unfortunately this is a sensitive reporting database and I cannot upgrade all 400 users to administration privileges without taking a huge risk !

Besides it really looks like a strange workaround for this particular bug...

Alexander Kappes

Hi Etienne CAUSSE,

alternatively you can only try to work without the Pager Time Function for Current Period and so on.

But the Change has no Impact for all Lite and Lite+ Users, because they are forbidden for the security from scratch.

The only "Problem" can be the Power Users which will be allowed inserting new Database Rules from that Moment on

regards

Alexander kappes

Etienne CAUSSE

I know they will not be able to use the security, however the Lite Plus users (and we have more than half for this DB) will be able to write into the cubes ; I cannot upgrade 100+ Db profiles and restrict cube by cube for this...

Alexander Kappes

for that case you can only wait for the fix in one of the next releases

regards

Alexander Kappes

Björn Reuber

Etienne CAUSSE wrote:

I know they will not be able to use the security, however the Lite Plus users (and we have more than half for this DB) will be able to write into the cubes ; I cannot upgrade 100+ Db profiles and restrict cube by cube for this...

Hi Etienne CAUSSE

so all accounts are set to Access Mode read? You can reach the same wiht using Access Mode Administrator and set all cubes (using set all to) "Read Only"

regards

Björn

Etienne CAUSSE

Hi Björn,

I'm well aware of this "set all" functionality but:

- already some cubes have "no access" in most profiles, so I cannot really do it massively;

- modifying the security profiles to work around this particular bug is a huge over-kill in my opinion.

- I would expect to find another equivalent way to provide relevant selections to the user in the report, rather than acting on parameters that have nothing to do with a dynamic time selection...

Björn Reuber

Hi,

I agree, that in your case this workaround might not be the best solution. We tried different stuff to get rid of this error and the fastest way was to change the security. In our case it has no impact on Security, cause access to cubes already was managed using enhanced BOARD Security

regards

Björn

Previous Member

It's not a perfect fix, but could you use a selector with a dynamic selection on the current period for the appropriate time entity? As long as 'Show Inactive Elements' is checked it could be changed similar to a pager, with the exception that it doesn't natively prevent users from selecting more than 1 period...

Etienne CAUSSE

Yes that's my big problem, the report shows End-of-month balance sheet values so it is absolutely required to prevent a display for more than 1 month.

Previous Member

Ok, got it. So if you made a new integer cube dimensioned just by month and filled it with '1's for all periods, could you then add it to your layout and filter the rows if it's not equal to 1? Then your report would be blank, and you could have a label behind it that says to select one month? Alternatively, if you don't want to mess with your dataview layout, you could stretch a label over the report and add a layout where it becomes a transparency only when the cube is equal to 1?

Using either of the approaches above, you could then likely use a selector instead of a pager but still make sure only 1 month is selected when the report is viewable. I know it's a bit of work, but it might get you what you need as a short-term fix?

Etienne CAUSSE

I had something similar to your second solutoin in mind, that I used in another report where there was a danger of inconsistent selections. I'll need to balance it versus the maintenance effort and usability.