Skip to Content
0
Former Member
Sep 10, 2007 at 12:21 PM

InfoView - How to Restrict values of Month Dimension Combo Box

19 Views

Post Author: alexrox

CA Forum: Publishing

Product: Business Objects Enterprise XI R2

Version: XI R2

Patches Applied:

Operating System(s): Linux RHEL 4 x86

Database(s): Oracle 10gR2

Error Messages:Steps to Reproduce:

Hello, we are using Business Objects Enterprise XI R2 in the company I work, and we are facing a problem in some web intelligence reports.Our BO version is in Spanish, so maybe I do not translate some BO terms properly into English.

We have the "Time" class in the Universe we use, and in that class, we have the "month" dimension.

When we create some reports in InfoView, we can use the "month" dimension to display the results of that month (dragging and dropping that dimension in the "Analysis Context" Area).

The user can choose values in the "month" dimention through a combobox in the "analysis context" area. The problem is that Infoview allows the user to select the value "all the values" of that dimension, I mean, all the months, so that the results of the report are according to the "automatic aggregation" calculated of the values of that dimension (all the months).

But, we do not want to allow the user to select that value (all the values) of that dimension, because it causes that the report displays incorrect results (we have some percentages that have incorrect values in the aggregation, for example). I hope that you understand the problem I have tried to explain.

My question is how can we restrict so that the combo box (of the month dimension at the analysis context area ) does not allow to select "all the values"?

Is it possible? If so, do we have to make a change in the universe or is it a restriction of the web intelligence repport?

Thank you very much!

Alejandro Usero Ruiz