Hi mmajdana Christian, Rob,Srini & Joel are experts in providing solutions for any issue (If you are able to explain your issue and desired output to show it to users). The current situation in your OBIEE: Store1 Store 2 Store 3 Shampoo 1 3 Your expectation in OBIEE: Store1 Store 2 Store 3 Shampoo 1 Sorry, No values for…

Thanks Rob/Chris for your advices. I am marking Robert's detailed reply & Christian's initial reply (both of your reply's) as helpful. I hope it will not make any bias on marking the correct answer

Hi Rob/Chris Thank you for all your discussion about this. Yes we have Row-Level security implemented and currently what i have done to make users happy is "Run as Recipient" at General section and in Recipients tab, added manually "Amar, Akbar, Anthony" full name. This gives only their records to view for now (i.e. Amar…

Hi All Can anybody shed some light on the above issue please Thank you in advance

Thanks a lot Christian for the links. Downloading the right Admin tool for Oracle Analytics Cloud. It seems 1.1 GB file to download and currently taking an hour time to download with my current net speed. After downloading, will try in the new admin tool definitely Regards

Hi Robert Yes we have row level data security and when user of one country logs in he sees the data of that region / country data only.

Hi Robert, Thanks for the link and your prompt reply. I am checking the link and will post my queries. Expecting mostly it will fit

Thank you Joel and Martin I got the Top 10 records as per your advise. However i don't know we can write SUM(query count) BY another attribute untill i saw your screenshots.

Hi Robert ErrorView Display Error State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. Please have your System Administrator look at the log for more details on this error. (HY000) State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. Please have your…

Just my 2 cents of thought on this issue. Try to export in .csv format of that report and later can be saved in 2007 version of excel. Thanks

Hi Arijit Thanks for replying. The Doc ID 2352581.1 tells report is not refreshed after clicking the "Refresh" link on an existing dashboard within OBIEE does not dynamically add "OBIS_REFRESH_CACHE=1;" to the analysis preventing the OBIS to execute the SQL from DB. but our OBIEE reports throws "View display error" and its…

Hi Joel Thanks for replying.Yes They migrated couple of months back from 11g to 12c. migrated some reports through catalog manager and some reports through Archive & Unarchive approach across environments. Not all reports throws error but few reports are behaving like this

Hi Christian/Gianni Thank you for the link to use VM box to run OBI 12c. My bad, i should have read the compatibility matrix before installing 12c. But it surprises me why cant the OBI software can check / provide an alert something like "OS detected as WINDOWS 7 and 12c is not compatible to your laptop - Compatibility…