Did you check the logs of the executed queries? When the agent is supposed to run (or if you execute it by hand), you must see the logs of the condition analysis executed, including the logical query etc. Look for that: is the query executed? Is it right? With which user it is executed? If the agent run as recipient you…

More widely I believe it's worth to think about your "need" from a global point of view. OBIEE as an enterprise wide analysis and reporting platform based on Excel file sources? It's probably easier and safer to get the Excel into a database first and use a proper database. DV can use Excel as source, but it has been…

2934375 wrote:But the presentation services is not starting after this change in the instance config file. And what does the log tell you? OBIPS doesn't stop starting without generating anything in the logs ...

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.