Hi, so you have a "good" and "bad" test case. So lets compare them. Get your user to go to the dashboard page. Or do it yourself if you can replicate the problem with your sign in. Then at the same time you go to "manage sessions" /analytics/saw.dll?Sessions, find their session, view log. This may help you understand what…

No it is not possible get a database connection to the oracle cloud applications database in real time using a third party tool such as microsoft power BI. You can use oracle business intelligence to view data real time that you get out of the box when you buy oracle cloud applications as software as a service (OTBI). And…

Hi, Yes you can do that. Select New, Data Model, select Data Sets, select New Data Set, now at this point you have 2 options a) select SQL query then data source Oracle BI EE type Standard SQL then cut paste your logical query text from your advanced tab in your analysis -or- b select "Oracle BI Analysis" then select the…

HI Shubham, Your response confused me. This is a forum. I am simply sharing with you my opinion on how I think things work based on my experience of using OBI over the last 10+ years or so. I am a user the same as you at the end of the day. I am not the product owner from your vendor. If you you do not like how the product…

In an analysis on teh criteria tab in your filters when you add a filter the default operator is "AND". But you can click it to change it to "OR". And copy paste them about to change the nesting. So if i understand you correctly you sound like you need a where clause that goes something like where "table.email" is null OR…

By "change filter" do you mean you created analysis X, for example, SELECT 0 s_0, "Time"."Calendar Year" s_1FROM "Absence Management - Leave Donations Real Time"WHERE (cast("Time"."Calendar Year" as character) = '1999')ORDER BY 1, 2 ASC NULLS LAST FETCH FIRST 75001 ROWS ONLY you added this to a "briefing book" A and then…

Hi, You cant have a prompt without a filter. The column in a prompt must match the column in the filter. If you do not "lock" your filter with "Protect Filter" = True then it will be replaced by the value from a matching prompt. So in this case year = 2020 in your analysis is therefore just your "default". If your user…

Assume this is your number format. Sounds like yours has a thousands separator? You can either change the number format or edit the formula to cast the number as a string. To change the number format in your criteria select the column, select Column Properties, select Data Format, select override, then make "Use 1000's…

Hi, "in OTBI but To_date function is not available" No I think this statement is false. OBI does include a function to_datetime() to convert a string to a date. I agree it is not listed in the list of functions in the user interface when you select edit formula then fx(...) to insert funtion. But it is listed in your user…

Hi, In the past on premise I have created many subject areas using OBIEE. But you are definite NOT allowed to create nor edit any of the subject areas in OTBI in SaaS with your Oracle Cloud Applications. BTW Included in your licence at no extra cost your Oracle Cloud Applications do provide a data extract service so you…

Hi, I had not asked you to try anything. I was asking you to state here exactly what presentation column from what presentation table from which subject area you had as your column in your dashboard prompt because your screen shot was ambiguous? The column in your dashboard prompt must match exactly including any functions…

Hi, Which subject area? If you edit your dashboard prompt, select the column, select edit (pencil), select fx (Edit Formula) next to "Prompt for Column". Cut paste the presentation table and column here. Assume you are using "Business Unit"."Business Unit Name"? Some pairs of columns are setup joined up in the metadata…

Use subject area "OTBI Performance Real Time" (21C). for example select all 0 s_0 , "BICC"."BICC Flag" s_1 , "OTBI Report"."Adhoc Flag" s_2 , "OTBI Report"."Custom Flag" s_3 , "OTBI Report"."Dashboard Name" s_4 , "OTBI Report"."Dashboard Page" s_5 , "OTBI Report"."Report Name" s_6 , "OTBI Report"."Report Path" s_7 , "OTBI…

Hi, A data type of date does not really have a format so a date is a date is a date. The format you choose in column properties is how you want to display the date in your view to your user. So the question is do you want the value in your download to be a "real" date or a string with a particular date format? Are you…

Amit, Actually you get BOTH analytics and reports (publisher) as part of OTBI. OTBI is what you get with an Oracle Cloud Application. You get he platform Oracle Business Intelligence (11.1.1.9) plus the metadata repository database (RPD) with the real time subject areas on top of the application database tables and views.…

Hi, Sorry no sure if there is a way to do this in OTBI in Oracle Cloud Applications. I have customised many times stand alone OBI "on premise". So you drop files on the application server with images and css and xml etc. with the fonts and colours etc of your brand to create a new "style". There is an XML file for all the…

Hi, Yes I think this can be controlled by security. A person must have a role that inherits author to move files from folder to folder. So you can revoke author privilege to only the people who need it. Let everyone else be a consumer. Only grant author to people who have the level of competence required. Drag and drop can…

Jacob, If you put your report on a dashboard page then you can make it use your dasboard prompt prompts instead. All you have to do is make it so the presentation variable name in the dashboard prompt is the same as the parameter name in the data model for your report. The limitation is that on you need to keep tour…

Hi, 1. "As per Oracle Support this feature is not supported" Please reference the thing you reference here. As per what support? Are you getting this from a certification matrix? Which sheet, tab, row, cell? Or an artilce we can read on support.oracle.com? Which feature exactly? If you can see the data in an analysis then…

Can you can do this using the time series functions ago() and todate() assuming your time dimension is exposed as a presentation hierarchy? Oracle® Fusion Middleware User's Guide for Oracle Business Intelligence Enterprise Edition 11g Release 1 (11.1.1) E10544-08 December 2014 D Logical SQL Reference…