You can create a session Variable and use it.
Hope this helps
Let me explain my requirement in a better way.
Actually my requirement is to display the columns based on the user selection. Like,When I select col1,col2,col3 from prompt the report should show only col1,col2,col3 and other columns should be hidden from display and download.
...display the columns based on the user selection. Like,When I select col1,col2,col3 from prompt the report should show only col1,col2,col3 and other columns should be hidden from display and download.
Sorry but ... isn't that what Answer is for?
What you describe can only be done in Answers, you can't have a dynamic number of columns on screen and in download. You are supposed to have a kind of placeholder for the columns and if only few are selected these columns would be empty, but they are still there.
So your "show only" is possible only giving them access to Answers.
And it would also be the best solution! Setup a new SA with the 50 columns and it's done (with no access to shared folders so they don't interfere in any way with the rest of your BI system).
This level of customization is not really achievable in dashboards... what you are asking is basically Answers.
In order to achieve exactly what you want you could create the measures as dimension in your star schema.
OBIEE Jeopardy: "What is Answers used for?"
But seriously, there's a REASON why you do one thing in "creating mode" Answers and other things in "consumption mode". The basics and reasons are covered in the first 2 hours of any OBI training worth its money.
We can get the basic information from any training but we can achieve from the alternate solutions. I am looking for something like that.
I think you people really not understand my requirement. I want to display the list of columns in the report layout based on the user request other than showing all the columns in the report one shot.
There is no simple show/hide button you can trig from a prompt.
You may try to use presentation variables but i don't think it will be a maintanable solution. Think what you are asking is simply not 100% possible, then again you could find ways of achieving it partially.
I understand perfectly what you want.
However, I think you don't understand the implicataion of your own question with regards to how OBI actually interprets analysis construction through XML and transforms that into logical and physical queries.
Each column in the CRITERIA TAB is and OWN XML TAG which is then REFERENCED in the VIEW CONSTRUCTION and hence the RENDERING.
How do you want to multi-select 1,2,5...N column names from a prompt and then hand that over so the analysis XML gets constructed and interpreted? Have you thought about that? There is a framework. And it's there for a reason.
What you want to do can only ever be achieved if you SPECIFY a SET number of columns and interact one-by-one with them. I.e. one prompt per column in the criteria tab.
Thank you so much for your positive reply but i am badly looking for the solution in an alternative way.
I just gave you an alternative way, you just didn't read it and think about it or the reasons + implications I mentioned. If you can't life with how this product is built, then I'm sorry.
I will not write you an XML-generating engine to create prompt-based analyses. Because....wait for it.....that's what Answers does. It creates XML structures. Which is what you're trying to do. You CAN. NOT. Dynamically creates a N-column analysis while it is being interpreted in a dashboard.
Dashboards are there to interpret file-system stored XML definitions. Not create them.
Ok, as you really want an alternative way, just some inputs for you ...
Everybody told you "Answers", so you know that what you look for must do the same work as Answers.
What does it means?
You need to produce the LSQL yourself on the fly based on the selected columns.
You can execute a LSQL via AJAX and get the result back, up to you to render it.
It will be lot of code, tons of bugs and probably stop working with the next patch or update (of OBI or your browser).
So fix a meeting with your customer/manager and tell him why it's better to spend that money for something else.
i am badly looking for the solution in an alternative way.
Yeh, you are certainly badly looking for the solution, I'll give you that
Listen to what Christian Berg is telling you. What you're trying to do is like wanting to travel from UK to USA an instead of getting in the proffered airplane are insisting to catch a boat, but asking that the boat will fly there instead. And if that's a nonsensical analogy then that is not entirely accidental.
Use OBIEE in the way that it was designed. Simple as that.
Thank you every for your inputs.
I understand the technology/tool, how it is working. Let's better discuss about any alternate approach to achieve the same but not more into the generic examples. Hope we are moving out of technology/question.
(And now I'm not telling you that you must use Answer and you want a flying boat, I just repeated myself to give you the only existing alternatives you have based on your requirement)