Hi, First thing first: a report as in BI Publisher report or an analysis in OBIEE Answers? The name defines the tool, the tool drives the answer you look for ... ( (c) Christian ) Assuming you mean an OBIEE analysis: If you set an aggregation like MAX or MIN on your "Planned Code" you get just what you look for. As you…

Charles M wrote:I'm going to delete the problem connection and call it a day for this one ... Beer time, sounds fair

Charles M wrote:So, knowing all of this. Can I add 2 more connections? One for the UAT instance and another for production? The whole reason for getting into this in the first place was so that I could connect online to our different environments. Not only you can, but you must do it Or you will really struggle if every…

Charles M wrote:By the way ... are the client tools "hard-coded" with the information specific to the instance that they were downloaded from? For example, if I downloaded the tools off of the 'Dev' instance, will it have only that information> No, the tool only filter available connection by "version" (driver used). It…

Dumb question: did you restart the Admin tool after editing/renaming the ODBC source? Because it seems it get the list when it load at the beginning but doesn't refresh it anymore. But never got the case: if the ODBC connection uses the right driver and you run the right (matching version) Admin tool it must be there. So…

Based on your needs, assuming the 2 groups will not try to destroy each other work, you can adopt normal multi development processes (and I don't mean MUD ) https://speakerdeck.com/rmoff/source-control-code-deployment-and-concurrent-development-for-obiee-12c?slide=55 Concurrent developments with source control and you then…

Hi, I didn't really look at your formula as I blocked on a first thing: you have COUNT(...) / COUNT(...) * 100 => you are doing integer / integer = an integer division, it can only return integers. Being close numbers it's probably the thing returning you 0 all the time. You need to cast at least one of the 2 (if not the…

chillychin wrote:Add the below tags in the instanceconfig.xml:<Security> <ContentSecurityPolicy> <Enable>false</Enable> </ContentSecurityPolicy> </Security> NO! Please no!!!!! How does it sounds like a good idea to just turn a security feature off instead of configuring it? Oracle official documentation cover how to…

Just like it will be to upgrade AIX 6.1 to 7 for a system you are going to decommission in few months. And as Robert said it isn't in the certification matrix, so you are all by your own if you still want to try the upgrade of AIX. And Oracle isn't going to help you in case of issues as OBIEE 10g is out of support…

That's why you need to look at the logs of OBIEE, not outside OBIEE. You now need to find out what OBIEE understand and try to do with these analysis (assuming it's an analysis and not a BI Publisher report).

You have a copyright on that one Christian, I didn't mention it to not have to owe you any money

Hi, Logs ... Look at the generated queries, check if there is some user based security which is applied to the users and not to your admin account, check if it's caching issue etc. EDIT: well ... Joel is quicker in posting

A little longer answer than Joel: it was supposed to be something coming with 12c, multiple instances support. In practice there isn't anything like that for now, therefor the short answer was "no" and the longer one is still "no". If really needed you would need to merge the 2 RPD into 1 or have 2 separate OBIEE instances…

Hi Farrukh, It all depends where the user comes from. You have a chance it is stored in the Weblogic internal LDAP, in that case log into the Weblogic Admin console, go in the security and search for the user. If you find it, you can then change the password there directly. If you can't find it (or can't change the…

And there we go! We "smelled" this tool was part of the deal and finally it's really there. I don't have that thing (and like Thomas I never wanted to use it), but it's a old thing. That's supposed to be an OBIEE account allowed to open the RPD online I would say, it's the only place where there is a username as a RPD…

Just what Christian said And if you were trying to do it in the RPD, you don't need the "by" syntax there as you have full access to all the properties of your model, so you set things by using content levels etc. That's why many on here had doubts about your model. As soon as you have a proper model with dimensions and…

As this thread is just like the other one about ColMax the same reply apply: The "by" syntax is perfectly valid and supported in OBIEE 12c. So give more info on what's your current situation and I'm sure the community will manage to give you some good hints on how to get over this point.

Trust me, I really prefer to be able to help people instead of proving them wrong ... This is OBIEE 12.2.1.3 (the exact same works on all the 12.2.1.x and also on 12.2.2.x) So, now that we all agree that OBIEE always supported (at least for the last 10 years) the "by" syntax in aggregations I guess it's time to make a step…

Because of MAX you need to do the sum yourself, so all you need is to use AGO twice to get the M-2 and M-1 value and add the current one. So your formula will be <measure> + AGO( measure M-1 ) + AGO( measure M-2 ) this isn't a valid syntax, it just gives you the idea on how to do

3744064 wrote:Thanks Angel but OBIEE 12c doesn´t aloud the syntax (by) OBIEE 12c perfectly accept and allow the "by" syntax. The question is more where and how you are using it. Did you build a proper model and is your analysis based on that? Because the "by" implies dimensions etc. to exists (or OBIEE will struggle in…