@Christian Berg and @rmoff are going in one direction, but maybe you want to go in the other one? Do you mean that you want to export the data collected and analyzed by Google Analytics about your website(s) and load them into your database to be able to do analysis in OBIEE on it? (so Google Analytics is just one of the…

Hi, Why do you use FILTER ? Based on what you wrote a simple CASE WHEN .... THEN .... ELSE ... END would be enough ....

Ok, so the XML for the conditional formatting is fine when applied to columns, but you decided by yourself to add it into <saw:displayGrandTotals>, right? If it's that then as said you can't, the XSD doesn't allow it ... (and it means there is nothing coded to manage it as well) For 12c I didn't hear about that but I…

Hi, I would say that using the web service is the only way to do it: http://docs.oracle.com/cd/E28280_01/bi.1111/e16364/soa_overview.htm#BIEIT3170 http://docs.oracle.com/cd/E28280_01/bi.1111/e16364/methods.htm#BIEIT286

Hi, where did you got that piece of XML from? Isn't it for OBIEE 10g or a really early 11g release? The XML definition changed over version, and in 11.1.1.7 that syntax is not supported, the XSD forbid it and it's why you have errors. The old way to add conditional formatting on totals doesn't work and as far as I know…

Sorry to ask Amrit but ... do you know a bit of how OBIEE works? Because it's about checking the approles (and which user, group, approle is member of an approle) and policies. It's a critical part of the security and so if you aren't familiar with the global security concept of OBIEE it can be risky ...

Hi, If you managed to do it with an ASO cube just do the the same. ASO or BSO cubes in the end are cubes... The main different is how you build your cubes as they probably contains different things with different structures. Also don't forget that an ASO cubes automagically aggregate when you query it, a BSO cube doesn't…

Hi and welcome to OBIEE, Yes you can connect to as many cubes as you want. The RPD accept multiple physical sources, so not an issue at all to connect to your 2 cubes. The detail is mainly what do you really except with "have one dashboard being populated by both cubes" : having independent pieces of the page or like a…

Hi Glenda, Out of the box there is not a single piece of info (data or metadata) of the catalog stored in a DB, it's all in the filesystem (the .atr files). If you look at SampleApp there are example dashboards and scripts on how to extract that kind of info and load it into a DB…

Did you try to search for that file on your install? If the install can deploy it when installing it also maybe store it somewhere. As far as I know it's not possible to download it directly.

I'm not really sure of what you really try to do as it works ... Conditional formatting on the Revenue column with condition Customer Name = "Adalia Abbey" and style BOLD (and background to make it more visible). Null cells, as said earlier, aren't impacted but the other cells on the row adopt the style. So can you maybe…

It's crazy what the doc contains ... (or the power of Google) https://docs.oracle.com/middleware/1221/biee/BIESG/configrepos.htm#BIESG9316

Hi, sorry but ... what is wrong with your totals? 42.88 - 36 = 6.88, and the totals are the sum of the values of your columns, so it's fine ... If you ask OBIEE to display your 42.88 as 42 hours and 53 minutes you are asking too much as in your example your data is normal numbers.

Hi, Did you check if your applications roles exists and if you have all the right privileges ? The migration with the BAR files also migrate the security, but some app roles names can be different or things like that. So log into EM and Console and validate everything on that side.

Hi, Which version of OBIEE? 10, 11, 12? In 10 and earlier version of 11 (if not wrong) it was possible to have conditional formatting on totals, in the last 11 (and I guess 12 even if I didn't test in details) it's not possible anymore: conditional formatting apply to values but not totals. Second point: is your null a…

Hi, In 11.1.1.7.* when you choose the "User input" = "Calendar" you can't limit the values anymore. If you want to limit the values (>= 1990 && <= CURRENT_DATE + 15) you must stay with something else like a list. The UI doesn't provide any way to limit values of the calendar.

Hi, What did you already try to solve your issue? Because you don't really provide any info to really help you in a more focused way other than ... reboot it and try again. The message is telling you it can't connect to the biserver instance, so the simple question is: is the biserver up and running? Are you allowed to…

sureshbhavana wrote:please give the solution Try with 42 .... Sorry, you don't really do anything to avoid random answers or jokes as you don't give any input (the picture just confirm what you say in the thread's title: there was an issue configuring the domain and it's step 13 of 14). So maybe you can look for some logs…

Well ... It can works for dimensions values only, but as soon as you have a fact OBIEE requires joins. A logical model in OBIEE must be a star schema, and OBIEE uses that when having measures. OBIEE doesn't work like SSAS, it's power is really to generate queries based on the business model using the physical model to know…

Hi, You don't have a single physical join or logical join and you are surprised that OBIEE can't know how to join your tables together? I guess you forgot the key element of the RPD: join things together so that OBIEE can know how to generate queries to find answers to the analysis you build in the front-end. You must join…