Thanks for highlighting this point Martin...

Please mark the thread as answered if your question has been answered so that other users can benefit.

Did you tried creating a System DSN?

Hello, You can refer the below link, but again its a lot of work and customization. Vishal's blog: OBIEE Hack: Putting prompts in file names This just gives you a way. You can use hidden prompts and the Presentation variables defined there instead of actual prompts. But, again remember the below... Hope this helps...

Can you please login to new OBIEE and check the About OBIEE under Help? Also, you can check the VA/DV URL by replacing analytics with VA in the original OBIEE link. These will give you an idea if you have successfully upgraded or not.

Sorry, for not getting it the first time... Though it is NOT Recommended, you can write a batch or some other script which will be executed post downloading the report/dashboard. You will have to think in that direction, if this is what the user's requirement is (which cannot be changed... )...

Seems like he is very famous.... 

If you can display both ID, Decision_ID column, then you can have a ID, Decision_ID and COUNT(*) because group by will be applied on ID and Decision_ID, giving you distinct combinations. Obviously a shorter format will be Count Distinct in RPD Aggregation or CountDistinct in Analysis (please note the presence of SPACE in…

Hello Avinash, Is this requirement just for the analysis? Can you display the date on the analysis (before downloading) as well? If yes, you can display the time in the TITLE Section.

Can you please close the thread if your question has been answered?

Can you please close this thread if your question has been answered?

Dear User, Please check the logs, get the physical query generated and try to run the same on the DB. Please verify if both the queries (correct and distorted) return same results? Also, please try to disable cache and then try again to follow above steps. This will surely give you the bottleneck and help you progress.

Dear, Can you please try to change the TABLE Properties of the analysis as below screen: Hope this helps...

Hello, Can you try to adjust the heading as well as the column value width? This will definitely work.

There are two sections (see screenshot from previous reply): USER BASE DN GROUP BASE DN Please modify these sections with appropriate values.

You wont get these options in normal Table type.

Did you excluded the "Measure Labels" from the list? Please see below: I believe this might be the reason for getting extra "grey-area"...

Dear Dimitis, This is OBIEE 12.2.1.3 version... I'm not sure why you are getting the situation, but by default, if I hide some column, it remains hidden...similar views with One probable cause for this problem can be below: You have removed the column heading entirely and decreased the width of the column (instead of…

Dear User, You can use something like this: SELECT '<font color=WHITE>' || 'CHECK THIS IS DEFAULT' || '</font>' AS DUMMY FROM DUAL; And modify Column properties --> OUTPUT: Hope this helps...

Dear Dimitris, This is very strange as if you are hiding a column, it should be hidden entirely. I'm not sure about the version of OBIEE that you are using. I tried to replicate your scenario, but unable to. As you can see from the screenshot above, the columns are hidden and I am not getting any additional spacing in the…