But when you try that you quickly run into trouble. By default you are confined to only the predefined ones:
From the OBIEE documentation:
To show your own defined variables (repository/session/presentation) in OBIEE you have to use the narrative view.
First you have to add the variable(s) to your query:
Then alter the column properties, set the column hide property.
Next open a Narrative view, set your descriptive text, the variables are referenced by there a @ and there column number (in this case 2)
Set the rows to display to 1
Reorganize your compound lay-out so that your narrative view is directly below your title
Till Next Time
Sometimes you stand corrected see: http://obiee101.blogspot.com/2008/09/obiee-title-view.html
thanks..It is really helped me to solve my problem
ReplyDeleteCan u pls help me to solve following scenario.
ReplyDeleteHow do I get columns in a table in to rows in Oracle BI Answers?
Ex:
ID Name Age Address
Xx xx xx xx
Xx xx xx xx
Xx xx xx xx
Xx xx xx xx
I want this for one particular name or ID (Ex: I mean after filtering)
Name xx
Age xx
Address xx
Did you try a narritive view with line breaks
ReplyDeleteAs u said I tried it…but I need results with column headings.
ReplyDeleteIn a narrator I call values as following.
@1[br/] @2[br/] @3[br/] @4[br/]
It showed only the value
xxxx
xxxx
xxxx
xxxx
But I need this like following
Name xxxx
Age xxxx
Address xxxx
Telephone xxxx
Can't you simple type the header in front of the the values:
ReplyDeleteID: @1[br/] Name: @2[br/] Age: @3[br/] Adress: @4[br/]
I know that it will give answer. But I try to get the column names automatically without typing one by one. Anyway thank you very much. For the moment I can manage it as u said.
ReplyDeleteI need to show prompt values in my report title or in a narrative view. I can do this with a Presentation Variable if I have only one value. But I am trying to show a date range and can't get it to work. For example user runs report 1/1/08 to 3/31/08. I need to show those values in the header. Any suggestions?
ReplyDeleteYou could split your prompts into two (dateFrom and dateUntil). That way you have two presentationvariables to show in your narritve view.
ReplyDeleteI have tried that but since it is the same field it isn't working
ReplyDeleteHi John,
ReplyDeleteI have a report in which iam using Minus operator and so I can't add Year or Month fields to be used in narrative. Is there a way to display Last Month of current Year in Narrative without having it in fields selected.
The following text can be used in a static text or a narrative view without adding the column in the reports.
ReplyDeleteTHE VALUE OF THE SESSION VARIABLE IS @{biServer.variables['NQ_SESSION.variablename' ]}
How can we set the master detail link in narrative view?
ReplyDeleteThanks,
Mohmmad Farooq