Hello Experts, Kindly help with this query. Thanks

I got the option, go to share at right top (<) then you can export it. Thanks,

I got the answer and sharing here with hope , it may be usefull for others with similar queries. Multi table select option is only available from OAC 6.1 version onward. OAS 5.5 is not having this feature in drag and drop mode.

Hello Experts, I managed to associate a new dim table to fact table in business model diagram using foreign key option in fact table at BMM layer ( as depicted in below ): However , I do not see foreign key listed here for other table joins in Business Model Diagram. I see only foreign keys which I manually created to map…

https://community.oracle.com/tech/apps-infra/discussion/comment/16806080#Comment_16806080 Thanks Gianni, Kindly advise if below is the right place to fetch underneath sql: At this place I can see ,sql for both visualizations are similar : Visualization 1: SELECT "Claim Line Coverage"."Brand"."Brand Code" s_1, CAST(NULL AS…

https://community.oracle.com/tech/apps-infra/discussion/comment/16804676#Comment_16804676 Thanks Chris, I got that -we can have only 1 RPD available at OAC at a time, however multiple models within same RPD. Once new RPD is deployed, old RPD related models will be no more available. Thanks,

After using full connection string as above, below error is not occurring: ORA-12154: TNS could not resolve the connect identifier specified However now query is getting timed out. I guess I am facing some issue in connection my OAC server with DB/Data Mart server. Thanks,

https://community.oracle.com/tech/apps-infra/discussion/comment/16804542#Comment_16804542 Thanks Gianni !!! Kindly help me -what do you mean by full connection string pointing to your database? Currently I am using below connection in connection pool at RPD: testhostname.us.oracle.com:1521/ndtpa_pol Here…

https://community.oracle.com/tech/apps-infra/discussion/comment/16804326#Comment_16804326 Thanks Gianni, this is very useful. last question- I can upload/deploy RPD at OAC by both means as below? 1) Connect through client tool and upload as you mentioned above. 2) Deploy/upload in offline mode like below: ./datamodel.sh…

https://community.oracle.com/tech/apps-infra/discussion/comment/16804304#Comment_16804304 Thanks Gianni for your help. Data Mart/Physical tables are on Oracle 19c Data base at one linux server which is directly accessible as it is part of same cloud region. Only thing is that it is different server/host. I have OAC…

Thanks Chris, I managed to solve the problem with your help !!!

Thanks, I got it .

Thanks Chris !!!

This is resolved. I am not sure why? what I did- I just deleted "Date Of Birth" Column and dragged again.

Hi Gianni, Thanks, Yes you are correct, I resolved the issue by following the way you depicted: Good this is that my ORDS API is also working fine now. I managed to get XML response for my HTTP request through some enhancement for my ORDS - Rest API. I am also able to generate report from this data set. Thank you again,…

Hi Gianni, Thanks for your help and guidance. Kindly validate if I am missing some thing because I am not able to view data: RSS feed for test: HTTP connection at BIP administration: Data set: view data: However this URL is working from postman: Not sure what I did wrong and what to fix. Thanks

https://community.oracle.com/tech/apps-infra/discussion/comment/16773582#Comment_16773582 Thanks, can you please provide some sample rss feed URL as example which I can also test please. Also I see webservice urls in google without port number , however in BIP- it's mandatory to provide port number for a webservice end…

Hi Gianni, Thanks for your help !!! Just to avoid any possible confusion , I am using HTTP (XML feed) connection and not webservice: my url is a REST API which I created on database tables through ORDS- Oracle Rest Data Services. I am able to access data in database tables through these REST API resources through POSTMAN…

Thanks Gianni for your help !!! I was searching for some youtube kind of videos on internet to create a BIP report with REST API data source , but in vain. Any step by step guide around this?

Hi Saresh, Thanks for your help !!! In my case, it is not a dashboard prompt. What I did: 1) I created a table prompt in my Analysis report 2) I created a BIP data model using this BIP report 3)I created LOV and parameter in this BIP Model(Parameter name at BIP model is same as table prompt name at Analysis report). 4) If…