I need to display in a pivot table :
- the total for the months selected;
- the total for the year.
How could we achieve this please ?
there are multiple ways to achieve this,
One of them would be to create a column in the RPD e.g. "Sales at year level" <- setting the level in the time hierarchy to Year
The rest is usual columns and filtering
Using the time dimension does not work completely. I give you an example related to accounts with budgets.
The user will use a period dashboard prompt to select some periods (e.g. 201701 to 201703).
Then I want to display :
- the account;
- the amount for period 1;
- the amount for period 2;
- the amount for period 3;
- the total amount for periods 1 to 3;
- the total amount for periods 1 to 12.
If I use a "Pivot Table", the problem is that I need to place the "Year Total" in the "Rows" area because if I put it in the "Measures" area, the "Year Total" measure will be repeated for each month.
If I use a "Table" view, the problem is that I cannot display the periods selected by the user in the dashboard prompt.
Tx for your help.
Where does the requirement come from?
I bet on an Excel file, right?
Just keep in mind OBIEE isn't Excel, things are done based on models and playing with attributes (dimensions) and measures (facts).
Dear
Set the logic for selected period in criteria 1 and total for selected period in second criteria and for 12 months in third criteria. Use union all and check if it works(Combine similar request feature)
like below
criteria1
column1 column 2
MonthName(Datecolumn) amount
filter - Jan to March 2017
criteria 2
monthname(Min(datecolumn) || ' to ' ||monthname(max(datecolumn)) amount
criteria 3
Year(datecolumn) amount
filter - Jan to end of year 2017 (use timestamp functions to derive end of year)
I did not test it. check it and let us know if any further info required.
Thanks
Aj
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
What am I doing wrong here? There is only one selection in the Target Canvas??
In BIP. I was able to group tables. Is this possible in OAC
I creates a parameter "Role Name" and then I put the Role name field in the filter and made a bind to the parameter, When I add the value in the parameter, it works. When I delete it from the parameter it give me <empty> How do I get rid of the <empty>
Hi, all, I have been struggling with connecting to Teradata in OBIEE Admin tool. I can't import Metadata to the RPD that exists. I am not sure about if it is due to my config of ODBC Teradata is incorrect or anything else? Please find the following errors as attached: Many thanks for your help!
Hi Team, Has anyone upgrade OAS system from the 2024 to 2026 version? if yes, could you please share the resposne files. Regards, Chand
