Convert columns into rows and vice-versa in Excel

We can chage the rows to columns and vice-versa very easily.

Follow the steps and get the result.

Step 1: Copy what ever you want to change.

Step 2 : Right click where you want to paste and select Paste Special


Step 3: Select Transpose option and click ok.


Thats it you're done

Dynamically Change The Column Names in OBIEE 11g

We can change the column names dynamically using presentation variables
see how it works.

Step1: Create a Dashboard Prompt for the presentation variable.

Step 2: Place the prompt in the ashboard page and hide it.

Step 3: Change the column name as @{Presentation Variable} {Deafult value}

Note : 1.Prompt should be taken on any different column other than the columns in the page.

2. If you want n number of columns,create n number of prompts and hide them.

Hide a Section in OBIEE 11g

Hey we can hide a section on a dashboard page.

Follow the steps

Go to Section Properties

Go to Format section

In CSS Style Write as Dispaly:none


Save ans see Run The Page