Honestly I have the feeling you are trying to make things complicated when they can be easy .... Why are you starting components one by one by hand? Use the start.sh script provided: it does everything and will run all the pieces in the background, so you keep your session once the script succeed. In the same way you have…

Hi, It's something else from a logical point of view: the repository schemas (OBIEE will require to create 5-7 schemas) will not be used as sources for the data you analyse. It can be the same physical database if you want, but OBIEE will create its own schemas there. The "simple" install will create them automatically…

Sorry but what are you asking? startWeblogic get stuck but you get the RUNNING state? So it's running?

Hi, Don't you have a backup of your system? If the file was there and you deleted it's not a problem, that location is just a "storage" place. If you want to retrieve groups from a database (while keeping authentication in your LDAP) then you need that file, if not you can stay without. The process of setting up the…

Hi, localhost or 127.0.0.1 will not get you anywhere because SampleApp isn't on your Windows environment. First thing: find the IP address of the vm and test it to make sure it works (so open your browser in the Windows session and open the <ip>:7780/analytics page of SampleApp by using the IP address). The IP depends on…

Hi, Of course it's possible to have filters when building an analysis on top of Essbase. It seems you are testing 2 completely opposite cases: does not work when you have a filter on a column and you add it to the exclude part of a view, works fine when you do not filter the column and keep it in the visible columns of…

Hi, No need to get a physical server, the idea is more to get yourself a VM with a server OS ... If your laptop / workstation has only 8Gb you will anyway struggle to install and run OBIEE (it takes looooot of RAM), and if you have 16Gb of RAM you can easily have 10-12 for the VM and so no real issue.

@3371002 : keep in mind to check what settings do you really need and want and not copy/paste a bunch of things in your config file, mainly when there are pieces managed by Enterprise Manager (as comments in the file tell you).

The idea is the system is smart enough to pass all the required things by itself. Thinking at your temporary headcount and permanent headcount, if the tile has a filter for "type of employee" = permanent once and "time of employee" = temporary for the second one, if you keep the column you filtered in the criteria of the…

3365160 wrote:In obiee 12c go to /<ORACLE_HOME>/bi/bifoundation/web/msgdb/<language used>/productmessages.xmland change text as below Apparently you do not took the time to read the first line of that file there in Cote d'Ivoire ... DO NOT MODIFY THIS FILE. THIS FILE IS AUTOMATICALLY GENERATED AND IS REPLACED UPON UPGRADE…

If you places "<custommessage>" in the file the issue is that it's parsed as an XML tag, so you must try to avoid anything having special chars from a XML point of view (at least for debugging).

Hi, It really depend on what you exactly look for (so what kind of values you want to pass from the tile down to the detailed analysis) but there are ways with the normal action link behaviour. OBIEE pass all the values of the columns (so filters), and there are also ways to pass other things by using the OBIEE logic…

A bad news and a good news for you The bad one is that you can't do anything at the analysis level to get 0% instead of empty (because it's actually really empty). The "display as" doesn't give you any control on the format of the column. The good news is that if you calculate the % yourself with a formula (so a real…

Hi, what is your exact OBIEE version? Did you have a look in MOS? There is a bug and a patch related to catalog and permissions, not sure if it's the same one you are having or not ...

What's behind that column? What formula did you use or how did you display that column? (I assumed something earlier but you still didn't clearly said what's that thing ...)

The XML changed, in 11.1.1.9 if not wrong that "trick" doesn't work anymore. The 12c XML theoretically still accept some code for conditional formatting of totals rows (XML accepted and saved because matching the XSD), but there isn't the required code to understand and execute that part.

Are you sure the result is really 550'000 rows? Because the result of COUNT doesn't really mean that's the number of rows you get (there are aggregations happening). Do you really have 550'000 on screen when you expand your table to show all the rows? Also keep in mind OBIEE isn't a datapump tool, so default settings limit…

No data is not null ! So do you have data? Is that data null? Or there is just no data for these cells?

Hi, What's that column? Where does it come from? It looks like a duplicate inside the pivot and then selected a "display as %", is that right? In that case I would say that the empty cell is the right one and you cheated on the format on the columns next to the % to display 0 when there is no data. No data is different…

OBIEE 11g was certified on Windows 7 (for dev only), so it was possible to install it. The 11g to 12c upgrade doesn't need to have an accessible 11g from the 12c install : on the 12c you generate a JAR which you have to copy to your 11g, run commands on your 11g to pack the content into the jar, move back the result to…