Have a look at this : Agents not working when :USER :PASSWORD used in connection pool Same situation, same issue ...

Hi, What are the values of username and password in your connection pool? It's maybe :USER and :PASSWORD ?

What are you going to put in "Measures" area of your pivot? There you are supposed to have at least 2 columns (and it's what is supposed to be your measures). If it's a column, a formula using 10 other columns or anything else doesn't make any difference ... If for each heading value (Revenue and Gross Profit) you are…

Hi, Are you sure your column with "REVENUE" and "GROSS PROFIT" is just a heading? Isn't it the name of the measures you will display in the pivot ? Because you have the same set of products repeated for both Revenue and Gross Profit, so this means you have at least 2 measures. In that case as long as your 2 measures are…

Hi, OBIEE will not complain at all if you use a date instead of a number. Everything will work without problems, no issues on that side.

Hi Dan, Did you try to switch your columns from "suppress" to "repeat" ? Doing this on all the columns where you want to remove the merging will repeat the value on each rows both in the dashboard and in the exported Excel.

One of the main changes between 10g and 11g is that security has been moved from the RPD to Weblogic. So the management of application roles and their members is now done in Enterprise Manager. In the RPD you see a list of application roles and users to allow you to define security or other limitations based on them but…

Hi, Which version of OBIEE are you using? You mention a document about OBIEE 10g but tagged your post as 11g. In 11g things works in a different way: you add users/groups to approles in Enterprise Manager. Look at the doc for the correct version of OBIEE and you have all the details (or also googling you will find tons of…

I would say that what the link is doesn't matter much. The thing is that if DV doesn't give you any option to set the target (html links generally use "_blank" to open a new window/tab or "_self" to say it should navigate to the link in the current window/tab), there is maybe not much you can do... You could try to enter…

Connecting all the dots... What you are asking is how to have an image in a DV workbook with a link, and when you click that image inside the DV workbook the link should open in the current window/tab and not in a new page. Did I understand your need correctly?

Do you really have dashboards? Or you mean DV workbooks? Is your homepage/landing page a dashboard (a real dashboard) or just another DV workbook? Is that homepage/landing page in DV or in 'classic'?

Did you search what sources are supported by your Essbase? Because that's the first step. If you find that your new source is supported, you can then start looking at how to make that connection.

Upgrade Publisher from an unsupported 10g to an unsupported 11g? Why not upgrade to a supported version that is less than 10 years old? The database being more than 10 years younger than your Publisher, it's probably the security settings limiting the version of drivers allowed to connect. If it's that (but you don't give…

Just remember one thing: 11g to 12c is a major version change, upgrade your catalog objects!

@BenFreez It's great that you had a fix and posted a message back here to say it came from Oracle. Just a note: if you got the fix through a SR, you can't share it freely. Other users also need to raise an SR to get it (because SR and MOS are paid private content and can't be shared publicly). Not that I don't want you to…

OBIA already support OAS, OAS on Marketplace is nothing else: just an OAS installed with standard config (and a number of issues because of a very poorly done install, but they started to understand that point and are slowly fixing it). Still, you maybe better install your own OAS in an OCI compute instance to have an even…

With all the respect for the people writing MOS documents: this is one of the most chaotic and poorly copy/pasted piece of content I have seen in quite some time (and I did send this feedback in the page). "Hey, let's take an OAC note, call it as OAS and not even bother in renaming things or making it look like we didn't…

I do get your point, but it's sadly a different generation of products: OBIA 11.1.1.10.3 is kind of stuck on the technical environment of OBIEE 12.2.1.3/.4 : WebLogic 12.2.1.3 and FMW 12.2.1.3. OAS didn't go much further away as it's stuck on WebLogic 12.2.1.4 and FMW 12.2.1.4 But that little .1 of difference is enough to…

That's exactly why I said that OAS doesn't touch your OBIA install: you keep all your current install, including WebLogic, FMW, ODI, OBIEE etc. OAS does its own life on the side, it isn't aware of OBIA because it doesn't need to. You only migrate the content, not the server.

As far as I know OAS is fully independent and doesn't touch at all your OBIA install (you keep it as it is), you just migrate the OBIEE content (RPD + catalog) on OAS and connect to that one. I didn't check if they now use the same WebLogic and FMW, they weren't the same versions and that's why OAS was just installed on…