The hierarchies are unbalanced. I therefore cannot use a particular generation column to determine on what generation the lowest member (level 0) is. I used a case statemen as follows to determine the lowest level: Case When Gen6 is null and Gen5 is not null then Gen5 When Gen7 is null and Gen6 is not null then Gen6 When…

Hi Gianni I cannot get the GO URL with parameters to work. Will you please have a look at my screenshots below. I have also attached the XML. All records in the target/detail analysis are returned... so the IsPrompted filter column is being ignored. 1Action_Parameters_Screenshot.png 1Action_Parameters_Text.txt…

Thank you Gianni. The OBIEE target detail analysis that is using IsPrompted as a filter is however a case statement and not a single column so the IsPrompted is not working. So I therefore need to set a presentation variable. How do I use the Go URL to pass the cell that I am clicking on in the summary report as a…

Hi Christian Here is an example: Essbase outline: XYZ (Parent) * Child 1 (Child of XYZ) * Child 2 (Child of XYZ) * Child 3 (Child of XYZ) OBIEE output required: Parent Child XYZ Child1 XYZ Child2 XYZ Child3

Hi Christian We are using OBIEE 12.2.1.4.0. I am referring to combining 2 results sets as in a union. See screenshots below: In the pivot properties "Include rows/columns with Null values" is not available: In your example it is showing all lines as the intersection with the Paid Amount column has data. I want the whole…

The conditional formatting is simply changing some lines to Bold font style. The default font style in the selected column's Column Properties is set to Regular. The conditional formatting logic is as follows: If the line code is T0001;T0002;T0003;T0004;T005;T0005 change the font style to Bold. I do not refer to the…