other options also : 1) create data set with filtered values. 2) put filter during report creation as super user and other user will not be able to modify 3) take the data in excel/csb and remove those records and then create data set and data flow using this file source etc

Thanks Alok, then it means that data visualization dashboards can not be scheduled (schedule email)?

https://community.oracle.com/tech/apps-infra/discussion/comment/16811268#Comment_16811268 Hi Gianni, Yes you are correct. My problem is resolved now: what I had to do is , make knowledge level data type from number to text, set aggregation to none and treat as attribute (earlier it was measure). Thanks,

Thanks Chris, I will test it and will get back to you !!!

Hello All, I got the solution and sharing here so that it may be useful for others with similar problem in future: Create below view on JDBC user schema create or replace view all_users as select * from sys.all_users where username = sys_context('userenv','current_user'); OBIEE/OAS's BIP is querying table all_users which…

I tried to restrict the access in the DB, so now data set user can not access the data of other schema. However other schemas are still getting listed. One can see what all schemas are available within the database. Thanks, Rajneesh

Thanks !!!

Hi Gianni, Thanks for your expert advice, it helps !!! May I know a bit more please to gain crystal clarity: 1) If I have common dimension or fact tables between these 2 repositories (let's say address_d ), then during merge it will not allow me to rename the conflicting name like address_d1? 2) As per my own research , If…

Q: Do we supply query via HTTPS request and query API returns a JASON response? is there other ways for querying and viewing results? Ans: The query can be provided using query parameters or a payload. Response can either be JSON or XML. Q: If I write a sql query (example select * from Table), how it will be converted to…

Customers can deploy OAS on-premises or in a private cloud. Customers can manage upgrades on their schedule and implement customization options such as custom skins/styles, metadata, messaging and more. All these views comes from an interactive discussions and difficult to get 360 degree views by reading only…

A query may appear vague due to lack of context understanding. Is there nothing to answer? Not even a little bit? For example- There is no difference between reporting tool and query tool as terms are exchange ably used in reporting context. Examples of query tool from on cloud perspective- Oracle: Self-service DV…

Hi Christian, I may have different opinion and let me disagree with you, these kind of forums help to fill up gaps between theoretical and practical insights and nothing can beat interactive and constructive confrontations to derive better conclusions. You do not need to answer each and every questions as no one on the…

Thanks Christain, OTBI can be mounted on any application for real time reporting or only selected applications ? Is this support only equi join or all kind of joins? Thanks, Rajneesh

Hi Christain, Thanks for your reply and it was helpful. I am a bit confused as below: 1) I read that "Oracle Analytics Desktop (OAD) compatibility will align with OAC" . Is that mean - we can integrate OAD with OAC? If so then OAD will also analyzes any data source you can think of? 2) I also read that "Customers can…

Hi Christian, Yes you are correct, DVD is OAD now. Any comparative analysis for DVD/OAD Vs OACS Vs OBIEE's Data Visualization with pros and cons, which product is having upper hand with respect to data security standards on cloud and why? what all additional features offered by one compared to other two? which is…

Hi Gianni, DVD means Data Visualization Desktop. Yes, OACS and OAC are same and mean Oracle Analytics Cloud. Thanks, Rajneesh

Hi Christian, Thanks for your reply, my query is not only related to OBIEE or DVD (this is mentioned just sake of example) , it was related to all possible dashboards in Analytics era which includes new trends of analytics like google analytics, R, Python, machine learning, data mining, predictive analytics based/related…