Not directly on your topic but related to... You don't need your OBIEE to be SSL to connect to a SMPT via SSL. In this SMTP connection your OBIEE acts as the client, therefore the SMTP will never know if your OBIEE is SSL or not etc. You said you tested with various certificates and even a self-signed one : that's not how…

The sorting column, your COLUMN_TO_BE_DISPLAYED, which you transform either all upper or all lower case, is not going to be visible. It's a technical column in the RPD, you use for sorting your link column and that link column is the one you will expose in addition to the existing content of the subject area. Setting a…

The UI gives you 2 options for sorting: ascending or descending. What you ask is, for that given column which is a custom formula, to have another kind of sort based on rules you set yourself. Obviously you can't get that "for free". The hidden column Jerry mentioned is the way to go for these situations. If you want to…

In extension to Jerry's answer, if it's an OBIEE analysis somebody maybe missed the point of modelling there. There are facts and dimensions and that's what make a model powerful as it can be used in various ways.

That's more a good practice than a bug : if you don't filter extremely well the definition of your users in the AD integration any user with valid AD credentials will end up being a BI Consumer. Removing authenticated users from any inheritance is normal in any setup (when you care about security). Still the bug isn't…

What about following the official doc or some MOS notes? (there has been quite a lot written on AD authentication) Keep it simple and stick to "certified" sources as they exists.

From a logical point of view @Jerry Casey option is better: why do you want to bother the system with EVALUATE when the native OBIEE functions are enough? From a business point of view, that's something you must have directly in your database. You can't trust the front end, every single analysis to always obfuscate credit…

So could you please say which exact tool/product (with version etc.) is it about? In this way a MOD can look at moving the thread in the right place.

Are you talking about OBIEE? Because you posted in but not sure if you really talk about OBIEE here ...

I would say your only chance would be to look in how images stored in the DB can be displayed. Your blob isn't a PDF, it's a bunch of 0 and 1, that's it. Your browser understand that a URL is a PDF thanks to some headers telling what is the time of the content it's about to receive, so you would have to go through…

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…