will outer join and include Null give you results if there is no data after applying filters? By No results i mean not even nulls

Your issue is that the initial "requirement" isnt a requirement but ignorance and unwillingness to learn. We have configured OBIEE to SSO through O365 and users see these reports on O365 pages, i dont think there is ignorance here it is just a fact that no results view is not what is expected to be seen on a page where…

Can i please get help with this issue

Pedro, Below is the screenshots, What my analysis will look without null entries. How it looks with null values, Now the business is asking that the null values should not come when there is data present in the condition. It should show when there are no results. Please let me know if you need more clarification.

Hello, Yes OBIEE 11.1.1.7.x is certified with Oracle Database Version 12.1.0.2.0.

Have you installed OBIEE previously on the same machine.? Please also set Java Home properly and try running it again.

When you took backup previously. Was that prompt catalog directly under shared folders or was it in a sub directory under shared folders?

As you are using Dashboard, suggestion by green4x will work exactly how you wanted it.

You want to display the month selected in a column or in narrative view? Do you want to show all the results from month 1 to month 5?

Have you applied the patch for the bug fix when using external AD? [When using Microsoft Active Directory or other third-party LDAP as the Identity Store and also using the virtualize=true option, you will be unable to log in to OBIEE. You should download and apply Patch 21895214 to the oracle_common home] Does the…

If you want to filter results based on the other report you can go to filter and use the option Filter results based on result of another analysis, there you can specify the column u want to filter the results on. Let me know if it helps.

That's Good Please close this thread if it answered your question.

Oracle Business Intelligence Applications Version 7.9.6.x Performance Recommendations (Doc ID 870314.1)

ok, So if i understand it correctly from Admin user you can see results The Ledger Name KSA and Fiscal Year 2016 filters applied to the Dashboard correct? I guess you have to check in the RPD. Presentation Layer : Please check which all groups/roles have permissions to view data for that folder Logical Layer : Please check…

ok, when you login with your username can you see results in that tab?

Hello, Can you please provide a snapshot of what error you are getting. Also it will be very helpful if you can provide following details, 1. What groups is your user in (Check in My account Roles and Catalog Groups. 2. Please provide the snapshot of the permission of one of the reports which is being used by the…

Being in BI Administrator role does not mean that u will have all the permissions, it still depends on how the environment is designed. Can you please got to Manage Privileged and check if you have something like that in privileges,

3213997 wrote: I can login OBIEE directly. You can login to OBIEE from the login screen or by appending details in the URL?

There are 5 Schemas that you have to install OBIEE 2 schemas - xx_BIPLATFORM xx_MDS OBIA 3 Schemas - xx_BIACOMP - xx_ODIREPO - xx_DW It is asking you for xx_BIACOMP schema(where xx is the prefix you use). Can you please enter that schema and see if it works.

Can you add all the filters in the same prompt?