I am not sure Thomas. I was asked about that question and it was for an OBIEE requirement. I was shocked like how it can be done in OBIEE analytics. Then I realized like that it may be done in BI Publisher. Hence, just put this question in the forum to get the response, if any. I just wanted to know like whether it is…

Actually I went for an interview and I was asked to insert a blank row in the report.There is a hierarchy column like P1 C1 C2 blank row P2 C2 C3 blank row ..... ....... ........ Where P is parent and C is child.

When we are importing Essbase cube in rpd, it is showing that connection type as Essbase 9+. But after importing the cube in rpd, in database general tab it is showing database type as "Essbase 11.1.2.3.500". But we are using Essbase 11.1.2.2.

we are using user "Admin" to connect Essbase. When I click on "Test" in init block section it is prompting "Empty result set".

Thanks for your reply..............

Currently I am looking for OBIEE analysis.

I guess for all the new entries which are missing in the S_NQ_ACCT table even you are running the OBIEE reports, the CACHE_IND_FLG is 'Y'. As per my understanding, those are not hitting the database and showing the results from Cache itself.

You can configured the timezones in obiee by below doc. https://docs.oracle.com/cd/E28280_01/bi.1111/e10541/configtimezones.htm#BIESG121 Generally the timezone you are looking in the front in the application is by presentation services from instanceconfig.xml file and in the database it is from bI Server.

Yes,If you need to use 2 different username/password for two different schema, you need to create 2 different database objects in the physical layer.

I was telling about report properties in the section in which it was kept.

Create another column in the report and in the column formula write below case statement : CASE WHEN product='WebCam' then '1' WHEN product='AC' then '2' WHEN product='Tv' then '3' WHEN product='Mobile' then '4' else '5' end This will generate digits in that column. Please right click on the column and select the ascending…

It wont be showing in the dashboard, until in the section properties in the dashboard n which you have kept the report, you go and click 'report links' --> Customize--> then choose 'Export'.

Please check the permission of userid by which you have opened the above report with the issue user.

Did you try with Weblogic userid?

You should have one connection pool per database in RPD as you are only importing the different schema tables from the same database. Otherwise if you really require two connection, then better do another fresh meta data import in RPD.

You might have done it when you make excel as the data source in OBIEE. You need to go the Control panel ->Administrative tools->ODBC -> User DSN and Add the new DSN source.

While importing metadata in the OBIEE RPD, you might seen an option where of metadata type import selection is there....you need to check the 'synonym' so that synonym will be appearing the rpd as well.

Please download the data in csv format in OBIEE and open it directly in excel.