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
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (SCM). The session will cover updates on Supply Chain Management and Procurement. Presented by: Anil Sebastian - Senior Director, SCM Product Management, Fusion Data Intelligence…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
