I'm not sure what do you mean by Gianni Ceresa wrote:So there isn't anything created, just the top page move down as subpage as soon as you add a subpage. Each page which you will create is in Catalog as dashboard page, doesnt matter if it is top page or subpage. Top page exists as single object, that's true. And you can't…

What you have done is just change display name, not rename the subpage. All the pages exists as a dashboard page (except this automatically created). You can check in Catalog. Anyway, thank you for the hint. But my answer isn't replied yet. Why this subpage is created at all?

Jerry, Many thanx Simple, and works just great.

Martin, What is simpler in this solution? How to display correct subpage based on selection?

Hi, This is the requirement, but description from link do not work. Case added after OR is returning error.

But can I have own/specified row numbers, or they can base only on dimensions from data model?

Dashboard prompt has 3 values for variable PV_VIEW: Workforce Trend Hire Trend Exit Trend Dummy report has formula: CASE WHEN '@{PV_VIEW}' = 'Workforce Trend' THEN 'Male' WHEN '@{PV_VIEW}' = 'Hire Trend' THEN "Person"."Generation group" WHEN '@{PV_VIEW}' = 'Exit Trend' THEN "Diversity"."Ethnicity" ELSE 'Male' END Result of…

Great hint. Thank you for help.

I know where the Pivot Table view is. But where is Pivot graph? EDIT: Good to learn something new. I must say that I didn't new that in Pivot Table view, you can add also graph. Works great!

Thank you Jerry. One additional question: to have it in one field it need to be concatenated. But CONCAT worsk only with CHAR. To have CHAR, it need to be changed to INT (as othwerwise CAST to CHAR do not work, becuase there is a lot of place after comma). But when CAST Month calc to INT, it is changed/increased by 1. Any…

Hi Robert. SUM By Year ends with straight line for each year which is the sum of the month for each month. Server complex aggregate do not change the scale. Still from 0 to 600k.

If nothing will help, solution will be to implement this SQL code in ETL. But I still have hope that it is possible to solve in presentation layer.

Hi Lee, No need to apologies I must say that after taking a break from the issue, your post was kind of inspiration for me. Not sure if I have understood your proposition correctly, but I have tested new idea/concept. Results still aren't perfect, but at least pretty close. I hope that someone can help me now to write…

Hi Lee, Thank you for detailed explanation and solution proposition, but it didn't solve the issue with days. Still are negative for start date with higher day number than in current date. Please also note, that for years difference, you can't use SQL_TSI_Year, as calculation will be wrong. It need to be done on month…

Hi, I saw mentioned topic, and didn't found there helpful information. I'd like to do it in one calculation, so how format mask can do it?

Hi, I understand, but the requirement is to find a solution on OBIEE side. How you would like to add single quote? If you will just add it in the formula, there is OBIEE error: End of the input has bean reached. Illegal syntax.

Hi Joel, Honestly saying what they propose is not a solution, it is workaround. * The CSV format used to export raw data and import to another system. * If you have leading zeros in your data, you should use a formula either in your request or in the rpd to enclose the data in quotes if you want Excel to not treat these as…

How can I confirm that? User has required to put 0's in empty fields, so I have assumes that it is null.

No, standard IFNULL formula: IFNULL(fact, 0)

Hi, Under mentioned link it is provided as solution for numeric values in pivot. IFNULL do nothing in case of pivot. There are empty values.