Right now BI Apps is only on ODI 11g, ODI 12c isn't supported (the certification matrix gives you details about the very precise version numbers, but that's it). I heard there were work done on BI Apps 12c (so coming with ODI 12c and OBIEE 12c out of the box) but like always there aren't never dates communicated or…

99% chances the question was coming right after, so I provide a reply before he even has to ask

Once you went through data types and fixed that part I can already tell you the follow up question you will have: why is the result of the calculation of your 4th column not right? The good news is that the result is actually right. You will maybe want to look for "integer division" vs floating point division:…

Hi @3257179, Can you please stop mentioning random people in your threads? It isn't the most polite way to do things ... Never forget we aren't paid to be here and if/when we reply and try to support users and the community it's on our own free time (otherwise it's called consulting and come with an invoice someone has to…

The thing is that "they wanted it like that", so it means it's part of their process to not require UAT to be a full environment. The theory I guess is that UAT must be just like PROD to be the closer as possible and avoid any difference between what you see in UAT and what you get in PROD. So it means the client has a…

2604234 wrote:What are the advantages of having them do a full OBIA installation in UAT (so basically all 4 environments) as compared to just having OBIEE 12c? Wasting time and resources and money. OBIEE 12c isn't part of OBIA out of the box, it's already setup "on the side" doing an upgrade just taking the OBIEE content.…

user13510619 wrote:Yes it is analyses. You remember you posted that as your first reply 6 days ago? Because you said it was an analysis!!!! And now you are posting a Publisher screenshot. So, can you please clarify once (and stick to it) what tool are you talking about? OBIEE analysis or BI Publisher report? Because guess…

Sorry but you keep thinking at OBIEE in the wrong way. Why do you want "SQL logic" on the CSV? It isn't you writing SQL in OBIEE, the tool generate what it needs to get the data it needs. It isn't your problem how this is done. If you import your 2 sources in the RPD and make a join between them that's all you need. Don't…

OBIEE can federate sources together. That's why you have the business model and mapping layer where you must ignore the technical aspects of your sources and only think at the business meaning of things. There you can federate the 2 sources together into a single common model.

Hi, I don't have BICS around and it's ages since last time I touched it, but in a prompt there must be a checkbox inside the pivot table properties to say to hide columns/rows without data. So try clicking either on the "xyz" icon of the pivot table and look for that kind of option.

If you import your file as external table in your DB or as source directly in the RPD, the modelling work is done in the RPD which means that any analysis in OBIEE will have access to it. But you have to model it, it isn't a thing like "open a file on the fly and just get a row out", the file will act as a source which…

If you think at how OBIEE works you maybe better see why you are looking at the problem from a wrong point of view in a way ... You are mixing some business logic (the condition of an account being in a list of values) with technical aspects (the CSV file). The CSV file can be read by a database as external table, it can…

Inheritance is everywhere, do not assume that by assigning direct permission to the user (which, by the way, we all agree is a bad practice and application roles should be used instead) you override any other application role inherited permission. Rules of permissions overriding aren't as simple as you could imagine ...…

Hi, First: report or analysis? Based on what you wrote I would say it's an analysis and not a BI Publisher report, right? And debugging / analyzing security issues is all about looking at what you have in front of you. Any conflict in permissions? Did you check the various app roles => permissions the user has? You are the…

1043392 wrote:Hi Gianni,Actually 11g and 12c both are the right models. I disagree ... If the model is right (really right) OBIEE would generate either the same query or one returning the same data (except if you played with DB features etc.). If the 2 environments return different results it's because your model isn't…

Hi, But which one of the 2 is right based on the model? Isn't the 11g one which maybe worked "by mistake" ? There isn't a magical flag that make things the same (ok, there is one but what is the point to move to 12c if you force OBIEE to act as an 11g?), so look at the query, look at the model and define if the tool is…

Hi, I highly doubt any 12c product (OBIEE or Publisher) is certified and supported on Windows 7. First of all because Windows 7 is ... old, and second because these are enterprise tools supposed to work on a server and not a desktop OS like Windows 7. Most of the users (will not say all as miracles can exists) who tried to…

It is generally possible using the bar/line chart to have the 2 axis and then switch the line to bars by editing a value in the XML of the analysis.

Review your formula, you must have an issue somewhere ... (in the one you posted for example you miss at least a closing ")" )

Hi, You can ... but maybe not what you want as for that you would have to cast the current formula to a char/varchar and then concatenate a $ in front. But I'm quite sure you can set a column format as "currency" and pick the "$" as sign even when you do a union. You just have to set it on the global column and not inside…