And what does the logs say? It's the first to do: look at your logs to find the reason why your components aren't starting ...

Hi, Oracle publish an Excel file named "Certification matrix" which provides all these info: http://www.oracle.com/technetwork/middleware/fusion-middleware/documentation/fmw-1221certmatrix-2739738.xlsx In the "Database" sheet you can filter on "Microsoft SQL Server" as "Database Vendor" and you find your answer: Oracle…

yaseennawaz wrote:... in which scenario do we add a column in physical layer to a logical table and in which scenario do we add it to a logical table source? It sounds a bit confusing ... You can't add a column to a logical table source (LTS) as this doesn't mean anything, but when you add a logical column to your logical…

Ok, at least now it's clear what you try to achieve Honestly I have no idea but I guess the answer will be found on the google side. Did you try searching on Google for that? You are probably not the only one looking for it, like for example http://stackoverflow.com/questions/26515033/google-analytics-getting-raw-data-logs…

You will need something a bit more complex for the filter as it must still be a SQL-like condition .... So you can try a filter like : ( '@{Dim}{xxx}' = 'Month' AND DAY_NUM_OF_MONTH = 30 ) OR ( '@{Dim}{xxx}' = 'Quarter' AND DAY_NUM_OF_QUARTER = 90 ) (Just to be sure: this is a filter you want to use in your Criteria tab in…

Plan B: set the format of your column to do the same work ...

<a href="...your URL..." target="_blank">URL <img src="...the path of the little picture..." /></a> Just use a bit of HTML to concatenate around your URL or something like that ...

Hi, You can't really interact with a column selector to know which column your user selected, so not really doable with a column selector. But you can do it with a normal prompt... You create a prompt containing your 3 columns and store the value in a presentation variable, in that way you can use the variable in the…

@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