3531239 wrote:In CSV, I'm able to export the same report but not in Excel format(as per the requirement it needs to be exported in Excel format only). CSV is a 100% format support by Excel since .... can't count, I was too young to remember. Before to go more in details .... What exact version of OBIEE is it? (version +…

Thanks for the spam, not sure what you are trying to test ... You maybe want to read the community rules.

Well, you can use a pivot. You seems to have 4 columns (ACT, BUD, Variance and Variance %) which are repeated by some attributes. In that case using hidden columns calculating flags will work. So you move the "condition" from the XML into the formula of the column (so it's visible and easy to maintain). But it depends on…

819624 has it right. As you are new, you need to know that the Admintool saving the RPD must always match the server version. And RPD can be moved to upper version (because upgrades of RPD are always supported) but there isn't a way to "save as older version". I can't remember what OBIEE version is the 326, could maybe be…

Hi, Conditional formatting based on 2 or more conditions is possible. The GUI way to make it would be by adding new columns to your analysis where you write formulas returning flags. The issue with your case is that you are using a table view, so that approach will not work because each column is independent. You can still…

Ok, let's try to take things from the beginning You said "sql result", so why aren't your 2 prompts standard "all column values" but instead you had to use a "sql result" for the list of values? Aren't these 2 columns you prompt for linked in a way or another in your model? Can't you just use the "limit values by" and let…

Hi, must be the week of the prompts as that's probably the 3rd thread like that I see this week .... In OBIEE out of the box there is a way to manage dependance between prompts fields, it works using the column prompts and the RPD model to refresh related fields. If your prompts are based on LSQL queries there is already…

Your answer is "archive" / "unarchive" . You can archive content from the front-end and you can also archive from command line (automated way) by calling runcat.sh . In the same way you can then unarchive from the front-end or by command line.

For the records, Oracle also wrote on the topic of "the best tool for the job" when it was about rendering / exporting tons of data (because I will never believe someone analyse 25K rows in screen). https://support.oracle.com/rs?type=doc&id=1558070.1 (for an older version but still valid for 12c)

Hi, So I guess you figured out it is possible, meaning there isn't a hardcoded limit to 25K rows or so. If you still have issues and limits (not seeing all your rows) just search here in the forum as there is around a post per week on how to set weirdly crazily high limits in terms of rows and cells. It isn't a single…

Hi, All you have is 2 RPD, the merge must be done by the Admin tool. No idea how the 2 RPD looks like but you have a big risk that they share common names as it's the same product (even if 2 different version). Names conflicts means lot of work by hand to resolve the conflicts or rename one of the 2 to avoid the conflicts.…

No, it isn't: http://www.oracle.com/technetwork/middleware/bi/biapps-11-1-1-9-2-2527682.xls It will never be I would say. For ODI 12c there will probably be a new release of OBIA (so maybe a OBIA 12c something).

A logical column formula isn't a SELECT LSQL. A logical column is attached to a logical table, a logical table has one or many logical table sources. The logical table source define the mapping between a logical column and a physical table or between the local column and another logical column. There isn't any SELECT ...…

Ok, so for Publisher in 11g it's maybe also related on the security implementation. For the header/footer of OBIEE I don't guess you can hide them, so your better option is the one Sherry George suggested (and the linked blog too): the GO url. Because it's an OBIEE (/analytics) link it will accept your nQUser & nQPassword.…

chillychin wrote:Im not privy to 10g, but I do see in the 11g enviroment that it did work for /xmlpserver - At least in my enviroment Interesting, I'm kind of sure Publisher wasn't cooperative in 11g That's why it didn't shock me that it doesn't work in 12c, and it can even get worse if you enable the "fake" SSO to not…

chillychin wrote:I am assuming that since the OBIEE 12c URL works, something similar should work for BI Publisher Your assumption is wrong. It always worked only for /analytics, from 10g already if not wrong. It never worked for /xmlpserver (Publisher). Publisher in OBIEE 12c (like in 11g) uses the OBIEE (fusion…

Aren't "Fact - Purchasing - Invoice"."Non-Compliance Spend" and "Fact - Purchasing - Invoice"."Compliance Spend" measures? Because they are called "Fact" but you do a SUM without setting any dimensional attribute (using "by") or by using an aggregation at a different level. So it sounds a bit strange to me and could…

What version of OBIEE? The chart related to the pivot doesn't like when you change the format to line in the XML, by default it makes all bars and the last measure a line. If you want to have the option to configure what is what (line and bar) you need to have a real chart by itself. You seems to say that in that case your…

The word "real time" not being mentioned but talking about "daily BI" OBIA is still a perfect match, but as said not worth the cost and work for just "few reports". OBIEE isn't aimed at star schema design, it is for any kind of data structure you have. Star schema sources are actually boring in OBIEE because there is…

As extension to AH R answer, there is actually a model but it's a different solution: OBIA (Oracle BI Applications). It comes with ETL and its own database warehouse model where your EBS data will be loaded by ETL and then the prebuilt RPD and analysis are based on that. Definitely not what you look for if it's just for…