So you have a new DB with the same old things (names) plus new ones. You don't want to keep using the old ones but switch all the existing to the new DB and extend the business model with the new things. Why don't you just change the connection pool to point the existing physical objects, business model and subject area to…

Almost there, the formula isn't fully right but it's the "arithmetic of dates" approach suggested above. The OP will easily be able to get the right one.

I actually meant any kind of real code where it's used. The error is about an analysis being filtered on a prompt, the prompt uses the variable. It's highly confusing also because every time it's hand-written pieces of error message or pseudo code. And I stopped counting the number of times it was a syntax mistake when…

So you maybe have a wrong syntax to reference it ... What is the exact formula / code / expression using it?

What exact version of 12c? Did you refresh metadata if you were changing the RPD online? Did you logout - login in between the changed? Did you try to just display the value of your variable in a dashboard page using a text block? Do you see it?

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