Gianni Ceresa

3703061 wrote:I am not asking about the basic reports which are built on top of any data source but I am asking about the live/online reporting through OBIEE or BIP. What is the difference between a "basic report" and a "live/online report" for you? It sounds like you call "live/online report" something special, but there…

in Live Analytical Reporting through OBIEE/BIP Comment by Gianni Ceresa Feb 3, 2020 6:17AM

What are you missing? By "role group" you probably mean application role. You are missing them where? Just in the file? Because not seeing them in the file doesn't mean they aren't there. Did you check in EM if you have them? OPSS is in the database, as long as they are there everything must be fine...

in obie 12c security issue Comment by Gianni Ceresa Jan 28, 2020 4:24AM

3248940 wrote:3. OBIEE - Made the deliver agent to deliver the content as HTML as inline rather than attachment If you send it as an attachement the size of the attachment will not change (if you don't edit it in a way or another). As you sent it as HTML look at the source of the email you received from OBIEE and the one…

in OBIEE Report size increases slightly more than double while mailing from desktop mail clients like T Comment by Gianni Ceresa Jan 27, 2020 5:58AM

You posted the LSQL (logical SQL) of your analysis, this doesn't tell you much as you can't test it directly in your database. Find the physical query that OBIEE generate and look at that one, the answer of what happen is there (and it also cover the point raised by Joel, if there is some row-level security the physical…

in Missing data when multiple companies being selected Comment by Gianni Ceresa Jan 24, 2020 10:07AM

Do the folder exists "for real" in the catalog? If you look on disk or via catalog manager? If folders are there, could be a permission issue?

in OBIEE 12c - My Folder not appearing in catalog for Admin Users Comment by Gianni Ceresa Jan 23, 2020 10:54AM

If you are using OBIEE you must have a proper time dimension, right? In this case use the AGO function. (AGO only works with a dimension having the needed levels and configured properly as time dimension)

in Way to get Previous month booking Comment by Gianni Ceresa Jan 23, 2020 8:46AM

The feature getting closer to what you describe is called "master-detail" : you have a master view which allows to set selections on details view. In your case you will need to add the country as a chart prompt field for your products chart. Setting the country in the table view to be the master and the products bar chart…

in Selecting a value in a chart filters other charts in the report Comment by Gianni Ceresa Jan 23, 2020 4:52AM

OAC (and not OAC Classic) doesn't allow to execute customer code, you don't have any access to the OAC server itself (ssh etc.). In some old blog posts they were using ODBC to connect to Redshift, downloading the driver, setting up an ODBC connection and using this ODBC connection in the connection pool. But in the OAC RPD…

in OAC to AWS Comment by Gianni Ceresa Jan 22, 2020 5:41PM

What Joel said if possible. If you can't that way have a look at https://www.youtube.com/watch?v=DQ5nAIpUa8M , it can give you some ideas of possible workarounds. Also https://www.youtube.com/watch?v=8BdAB8ictvA can give hints for a workaround.

in Way to get Previous month booking Comment by Gianni Ceresa Jan 22, 2020 7:51AM

Agents can run in 2 ways: - a single execution of the agent and sent the result to many - run as recipients: OBIEE login as every single recipient and send the result only to the recipient itself If you have 10 stores and want a single agent to deal with that, you need 10 different recipients which are going to filter the…

in Data level security for OBIEE Agents Comment by Gianni Ceresa Jan 22, 2020 6:52AM

Welcome to the Oracle Analytics Community

Gianni Ceresa Mod

Comments