You are mixing ' and " in your formula, breaking (ending) the string too early. Correct your usage of ' and " and give it another try.

You maybe want to ask internally for this. Analytics has a group of sales/PMs who must have all that written and ready already as they spend their days repeating those things to prospects and customers.

You have the source, you know what is your target format : not many other ways thank transforming it yourself. That's the best you can get .... I still have no idea of what the result you hope to find looks like... Did you try "Tools" > "Query Repository" ? You can export the result of queries in CSV ... Just don't expect…

3934657 wrote:a requirement to list all the obiee rpd joins Hi, Do you mind be a bit more explicit in what you are after? Maybe with a little example? The concept of "join" can have various meanings, so better to be explicit. And please also specify the exact version of the tool you are using.

Some basic things like version of the tool would be helpful. Did you check the RPD? Any error you maybe can fix inside?

Sunny86 wrote:The option to migrate through archive/unarchive from catalog in obiee analytics not working..but copying the folder from server to server is working Just keep in mind that's not a supported way of doing things. So you better be careful on what you copy around. And if you destroy your system because of a wrong…

Did you google that? Many wrote about this .... If you setup an ODBC connection in your OS, in the RPD you must identify the ODBC connection you setup. If you enter an IP of the server, why did you setup an ODBC connection in the first place? If your ODBC is on the system with the Admin tool, you can't expect OBIEE to be…

SUBSTRING doesn't take a FROM position and a TO position, but takes a FROM position and FOR number of characters. You now have the position of 1st *, and the position of the 2nd *. How do you get the "FOR number of characters? One minus the other: position of 2nd * - position of 1st * = number of characters from the…

So you want to build a new physical layer based on the new DB, build a new business model based on the new physical objects, build a new Subject Area based on the new business model. Once done take the existing subject area and replace it with the new one, which will have the same names as the old one, plus all the new…

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