OBIEE doesn't speak SQL but LSQL, so the prompt expect a LSQL query there. You can get the last day of current month in various ways, either using your time dimensions (which could have a flag to identify that last day of month) or by using some arithmetic on dates starting from the current date. Turn your query into an…

Yes you can, as long as you have the permissions for it. The name "Shared Folders" is more to make it clear it's shared (opposed to "My Folder") than indicating only folders can be created there inside at the top level.

If you have a high-res screen (WQDL or 4k) you can maybe try in Windows 10 to play with the compatibility options for high DPI in windows on the executed file. Never tried and maybe will not do much, but it helps with some apps not following well the global zoom factor.

What about you look at all the formulas in the formula editor and check out "ROUND" ? It has a little example and few lines explaining how it works. The target isn't us giving you fully working code but you learning the tool. I'm sure you can do that part (ROUND is almost the same in 80% of the languages and tools)

If what you want is that every single row has the same value, edit the formula of the columns, and there inside you enter your text with single quotes around: ' Your employer name ' You need the single quotes to tell OBIEE it's a static text, and not something to evaluate as LSQL code.

This is worth reading: https://docs.oracle.com/en/middleware/bi/analytics-server/whats-different-oas/index.html

And a new "update" added to my blog post: that post has almost more updates than original content now

Hi, Would be easier by using the proper names of tools. If DVD there is only one (assuming latest version), there isn't a real product named "Visual Analyzer" and also OACS isn't a name anymore. I guess you mean OAC? You maybe want to read your (Oracle) own releases: OAS is a thing now, reducing the gap between on-premises…

Don't be jealous Christian They will try to fix it but eDelivery isn't directly managed by Analytics PMs team, so ... will see.

It's like if you were moving your OBIEE 12c to OAC. So go through the doc for moving to OAC and you have the details. Keeping it simple you need to package all your content into a file and that one can be provided during the configuration steps of OAS.

While there isn't a date set as of now (not that I'm aware of at least), it's fair to assume the "one year grace period" the document linked by Christian mention could apply here as well. I don't believe they are going to take OAS as a different product and therefore have a longer support for 12.2.1.4.

A SELECT isn't supposed to lock anything. As a query is happening it will add an extra activity which wasn't there before. It's impossible to say that it will have no impact: it depends on what kind of queries you will execute and your DB itself etc. You have to try to see what happen based on your environment and needed…

Both OBIEE 12c or BIP 12c can do that : the tool doesn't care what your source is. If you connect to a DWH loaded by ETL the tool will show you "old" data, if you connect to a live application DB the tool will show you what it founds at the time it executed the query (when you open the analysis/report or based on the…

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…

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...

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…

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…

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?

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)

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…