Could you search your NQSConfig.ini file for FMW_UPDATE_ROLE_AND_USER_REF_GUIDS and change value from Yes to No and then try restarting the BI Server?

Hi @Wij Are you trying to refresh user GUIDs? I noticed this in your log file: FMW_UPDATE_ROLE_AND_USER_REF_GUIDS inside NQSConfig.INI is set to Yes but the server failed to connect to BI Security Service.

It's been mentioned before in the post. The latest version of OBIEE is 12.2.1.1.0. There is no other version newer than that. As as far as I know, Oracle are yet to schedule a release date for 12.2.2.x

Hi please check log files speifically the obis1 and obips1 logs which you can find under the ORACLE_HOME\user_projects\domains\bi\servers directory.

As Gianni said, it will be much easier and much more beneficial to your model to have a time dimension. Trying to simulate a time series without a time dimension and then a time hierarchy is possible but is prone to have all sorts of issues down the line.

just add an is Prompted Month filter to this report and it should restrict the report the the prompted Month from Dashboard Prompt. It doesn't have to be a display column.

so what are the conditions for displaying the yearly or monthly reports? All you need is to put both reports on a dashboard in different sections and then you apply a condition on each section. The condition will determine whether or not the section is displayed. To achieve this you could have a third dashboard prompt,…

Not quite clear on your requirement. Correct me if I'm wrong. Do you require to display data in a weekly format if Month is selected? What should happen if Year is selected without a Month value?

coul you check the credentials used in your OBIEE DSN? You could try creating a test DSN and checking if that works.

Have you checked whether the password is case sensitive? Can you connect via SQL plus on the server to the database?

The first thing would be to try to do a TNSPING to the database from the OBIEE server.

Assuming you have a Date Dimension, you can do something along the lines of: In your column formula: COUNT("Time"."T00 Calendar Date")

Hi @3283263 A quick way to get round this would be to slightly modify the column formula of your 3 measures. Use the formula IFNULL (expression, 0) to force the column to always have a value and NULL values will be represented with a zero.

Take a look at the following: Oracle Support Document 1352697.1 (OBIEE 11g: Error: "'Unable to create a system user connection to BI Server while running user population queries" Presentation Server Fails To Start) can be found at: https://support.oracle.com/epmos/faces/DocumentDisplay?id=1352697.1

There should be a BIAdministrators Admin Role which should be selected for your biadmin user to have BI Administrator privileges.

Hi @choracy69 Have you taken a look at the BI Server log file (nqserver.log) as well as the Presentation Services log file (sawlogn.log)? These may give you some more detail of what the issue might be.

Hi @2889517 As @Christian Berg has suggested, have you checked that your biadmin user has access to the Home Page by checking the Manage Privileges screen (in the screenshot that he provided)? Have you you tried logging into your WebLogic Admin Console to check that your biadmin user does indeed have the BIAdministrator…

and also screenshots of this column in BMM & Physical Layers of your rpd

I totally agreed with your OP @Thomas Dodds. I'm obviously a bit biased with my questioning of migrating from BO to OBIEE but as you said about OP, these decisions are sometimes imposed on developmen teams and it is best to find out the differentiators and make use of those as opposed to a straightforward copy from…

My 2 pennies worth - I'm not quite sure what business value there would be in migrating/copying like for like reports etc. You'd need to change software to add business value but that's just my 2 pennies worth and +1 to @Christian Berg with regards to moving from OBIEE to BO.