Do you have the folder at least? What does it contains? Are you really using 12.2.1.1.0 of Admintool? Because "data-model-cmd.cmd" is the old name of the script as used in 12.2.1.0.0, and the file also was in a different folder. It has been renamed and moved to be consistent from 12.2.1.1.0, so it looks like you are using…

SasDutta wrote:I am using Sample app V6. What is V6? Looking at OBIEE Samples the numbering of SampleApp VM is 3 digits (first one for the year in general and the other 2 for the month of release). So you are using v607 ? It would be 12.2.1.1.0, so at least it matchs your Admintool SasDutta wrote:I am using just…

Post more details: what's the version of your Admintool? Does it exactly match the OBIEE version of your SampleApp 607 VM? What's the full command you used?

You have SYS access to the DB, connect and look at the existing schema and you will be fixed in 3 seconds with the answer. If they aren't there you can install them yourself: https://github.com/oracle/db-sample-schemas

SasDutta wrote:In my host machine host file I mapped the ip address with demo.us.oracle.com Apparently you don't really care about replies, but stop doing that, it's a useless step ! Your VM get an IP by your network DHCP, which means it can potentially change IP at every start. So you end up editing your host file all the…

In addition to what Christian posted (which is actually how you can get the IP to use), forget "demo.us.oracle.com" as that thing doesn't exist anywhere else than inside the virtual machine itself. So only IP works to access the VM (replace "demo.us.oracle.com" by the IP you get from the "What Is My IP" tool).

Hi, If you see the different queries you can maybe at least post more details on what you are doing, what your model is like and what the 2 queries are. If you select col1, col2 and a sum(measure col) and nothing else it will probably be the same, so to get different queries you must have something a bit more complex than…

You don't have to do anything, the "at each execution" is OBIEE doing the job. Looking at this screenshot you see the 2 possible values for "Run As". If you agent is "Specified user" it means OBIEE execute the dashboard page only once as the specified user and then will send the result it got to all the recipients. If your…

Well, in general things are the other way round: users come from the company LDAP and so they also already have a "business" link with the office. If you don't have that then you need a table with just "username", "office" and then you session variable will select "office" where "username" is equal the login of the user.…

Hi, How to relate users to offices is something only you can answer, as it's strictly related on your business. The idea is to set a session variable for each user defining the office(s) he can see, and then you use that variable to filter the dashboard.

You need to not double post! How to change the column value names in OBIEE It's against the ODC forum rules (maybe worth a refresh) and you got your answers in the other thread. So go back there, mark as required if you got the answer or just ask more details of you don't get what the replies means. The answer is there (it…

(missed a bit of my answer) If the agent send a page you will need to "solve" the 1 to many link between a page and objects, for that the scripts to parse web catalog you get from SampleApp 607 can help you getting this mapping. So you can link from agent name to agent analysis (via the agent ID) to UT (by the path) or…

I don't have a DB with a RCU available right now so it's an answer based on what I remember ... There isn't a direct link (column = column) between the agents tables and the UT table. You can only try to go through the path of executed object. The real reference of what an agent execute is in the agent XML, in the DB you…

Hi, you can do it with a CASE WHEN. It will work but it's not really the right way to "fix this". You are supposed to have the "friendly" value in the DB directly, maybe in a lookup table if you don't want to add a "friendly" column to the table itself. If you implement a CASE WHEN in OBIEE you better do it in the RPD at…

3580870 wrote:Anyone provide me the solution ... Provide all the details and it will be easier to try to get you in the right direction : More in general you can definitely start by investigating browser cache, mainly if the new logo is visible in all the other pages except these 2.

srikanth_p wrote:I already joined fact to month table ,fact to qtr table ,fact to year table using there respective keys . I just can't picture that in my mind: you have 3 tables for your time dimension? In general you have a single time dimension with many columns, one of the columns could be "year_start_date", so you…

As always the changes in query generation aren't officially listed, but 12c changed quite a bunch of things on how query are generated. That's why there is a flag to make 12c work as an old 11g, but don't get me wrong: I'm not saying you have to do that as you are going to lose all the new things, so what would be the…

Hi, I didn't read all the details (of the query etc.) but few hints for you ... You can maybe try to add sequence numbers in your time hierarchy to help OBIEE generate a simpler query. As your issue seems to be on "when" (where) the filter is applied it will maybe not change anything, but still worth a look. Never forget…

Hi, Are you expecting someone here to randomly give you figured on how long it will take to migrate your unknown 11.1.1.7 (without more details on the version) to an unknown 12c (without any detail on the version) ? Doesn't really work like that ... Nobody can give you any of these figures, just because they only depend on…

If you got what you were looking for, can you mark as required and close the thread? It will help others with similar questions finding the appropriate answer. For now it's still This question is Not Answered.