Hide the column as per prompt selection

User_R93U9

Hi,

Is it possible to hide the column from an analysis based on the prompt selection i.e. when "None" is selected in the prompt the column doesn't appear in the analysis. I could achieve it using column selector but i need to achieve it using prompt only as column selector doesn't appear whenever there is no results in the report . I don't want to create two separate analysis and placed them in different section.

mac2

I don't want to create two separate analysis and placed them in different section.

That eliminates what would probably be my first suggestion then.

Another hacky way would be to use a case statement to display an empty column or even a "No Column Selected" type of value. But technically this doesn't hide the column as you've asked. But it would be something like:

CASE     WHEN @{pvYourPresentationVariable} = 'None'      THEN ' '      ELSE "Your Table"."Your Column"END

But that of course is a bit lame and doesn't technically hide the column.

Maybe it would be possible to hide it with a bit of javascript? Have you considered that option?

User_R93U9

Thanks Mac2.

I have tried the option suggested by you (case statement) but it doesn't work as it shows a blank column i.e. only borders of the column. I am not able to hide these borders.

It will be fine if column technically column is not hidden but it should not appear in the reports. Can you please help me with the javascript?

Gianni Ceresa

Honestly there isn't a easy way to make it and the javascript you are going to write can stop working at the first patch or upgrade.

The cleanest way to really not have the column on the screen is, as you said yourself, 2 sections and then display one or the other based on a condition.

What @mac2 gave you is the closest workaround to a similar result, where the column is still there but empty. As you said the borders are visible as the column is still there ...

So instead of trying to get into javascript with all the risks and the maintenance it will require, if you really don't want at all that column on the screen, make the 2 sections: at least you use an OBIEE solution which will always work (for sure for the next years, who knows what OBIEE will look like in 4-5 years).

3281045 wrote:...  I don't want to create two separate analysis and placed them in different section.

This is way simpler than javascript, so if you really consider javascript go back to this one. A single analysis with 2 views (or 2 compound views using 2 different views). In a view you have the column, in the other you place it in the "excluded" part.

You then create a super simple analysis being the condition (you can make it in a way to not even send a query to the DB, so super fast and simple). You now have everything to achieve your expected result.

mac2

I stumbled across this today: OBIEE in IL: OBIEE - Selecting columns dynamically - part4, working with and selecting none

I thought of your question and think this could be very useful for you. You might want to read the whole series as well.