create a new report and try. I cant find any reason to display like above and it is working fine for me in IE and Chrome. Also going through your second requirement, I dont think it is for OBIEE. Why not convince the client to use OBIEE styles than the existing style from excel. If you are replicating everything as excel,…

Dear, It is not required. Where exactly you kept the code? kindly provide a print screen. Try increasing the height of pane and reduce the font size.

You need to keep both in code. it is working fine for me . Try to reduce the font size and check.

did you try in IE?

transform: rotate(90deg); or transform: rotate(270deg); ( for opposite direction) in the custom CSS Use -webkit-transform:rotate(90deg); for other browsers other than IE

For your first issue, Could you try below code in the custom CSS incolumn properties in pivot. writing-mode: tb-rl; filter: flipv fliph Second issue, will check and update you

Dear Manoj, Yes it will. and it is obvious when we apply a filter for the right side in left outer join, it is no longer an outer join. You need to apply the filter before you join. if it is a smaller table create a view in RPD and filter the column in view itself. If it is required dynamically you can pass a request…

what is the begin time and end time shown in job manager (job instance view)? What is the last run time and next run time shown in (Job view)?

Date '@{PV}{2017-04-30}' will do

There is no reason i could find for this .. did you increase the number of records in agent in enterprise manager. Can you please increase it to the maximum report can have and try.? by default agent will send 75 records.

Hello Sergio, Could you please check the column formula where this value getting used. Try it in the below format. Date '@{PV_DATESM}{2017-01-30}' Not in your prompt, but in the report.

100%

Create an opaque view in RPD and use it in reports.

what are you trying to achieve with Having clause.

Bookshelf v8.1/8.2: Configuring Siebel CRM to Automatically Delete Reports

Dear Chandra, There is an option in OBIEE to achieve this without any SQL But if you want it to work you cannot use SQL Results. For that you need to bring the data in columns(the same filters you are applying here should be at RPD level). when i selected male in first prompt it is displaying only Male Actors. When i…

https://gerardnico.com/wiki/dat/obiee/opaque_view obieenow.blogspot.com/2014/04/opaque-view-in-obiee.html

Can you try creating an opaque view in RPD(which is not a great practice) with the two prompt columns and apply all the filters required there. Join it with the fact and use if for prompt. Then you can constrain the records at prompt level and no need to use SQL results.

You can find many related questions in the forum with a search such as below..

Cant you use constrain option? Isnt the columns are related?