Please read what has been posted ! Gianni Ceresa wrote:It's not about finding the current version as the problem is often that 80% of the catalog is on the right version but you still have objects with a older version.So just check/update the full catalog.If you login to OBIEE, go to the Administration page and then click…

They are different OBIEE actually use the .atr file for the check, the XML is probably there for future usage if needed (bug fixing requiring a mass change of XML to be fixed). But the main point is still that it's not something to be checked by hand as it must be checked for everything ! Every single file in the catalog,…

Actually both Cesar and Christian are right .... Cesar reference http://slc02olc.oracle.com:7780/analytics/ while Christian reference http://slc02oks.oracle.com:7780/analytics/ . Both are running Sample App v607 using OBIEE 12.2.1.1.0 . For mobile is mainly the one posted by Cesar which is used (look at the sessions of…

The XML also contains an optional version reference: For example 11.1.1.7 was only "201201160" and now 12c accept "201201160" or "201302130". Doesn't look like it's something linked with the "Scan and Update Catalog Objects That Require Updates" as running it doesn't update this number, but can maybe have in impact in…

It's not about finding the current version as the problem is often that 80% of the catalog is on the right version but you still have objects with a older version. So just check/update the full catalog. If you login to OBIEE, go to the Administration page and then click on "Scan and Update Catalog Objects That Require…

Hi, The message is quite explicit: open your init block and associate it with a connection pool. PS: you have one init block by variable? You can probably have a single D_Current defining all your D_Current* variables ... : 1 query returning many columns vs many queries returning 1 column each, the first is better (less…

Hi, "XML Search and Replace" in Catalog Manager is what you look for as it will do all the job in one step (ok, maybe 2 or 3 for safety...). Of course do not try to be smarter than what the tool is, doing a "search for 'ABC' and replace by 'XYZ' " because as you said it will replace it everywhere without really looking at…

Also the positive thing is that even if migrating your content from 11.1.1.7 to 12c it will not switch back to flash. 12c is by default HTML5 and will stay like that except if you really force it to something else. Good luck with your migration

Hi, Open any page in OBIEE with a chart and right click on the chart, if it's flash you have the menu of flash. Plan B is to look at the source code of the page. Plan C to look at the loaded objects: if you see *.swf you have flash

YEAR() to get the year from a date Date '....' to tell OBI the '....' is a date @{P_DATE} the value of the variable {2016-03-03} the default value if the variable isn't set

Check in MOS, there is a document about that. There is one for OBIEE 11g and didn't checked lately if they wrote one for 12c as well. If they didn't and you don't want the 11g and "adapt" the solution for 12c you can ask Oracle to give you the steps for 12c and they will write one for 12c I would say. The simple way is to…

First a note based on previous answer: keep in mind that if you uncheck it and don't install it you will not be able to install it afterward without doing a full OBIEE install again. On the other hand if you install it you can disable it afterward ... In 11g the embedded Essbase required the Foundation Suite license. It's…

Just a detail: the javascript way only work on a Windows Server ! As the OP don't provide a single information ( ) it's impossible to know which OS his server uses. EJB will work in both Windows and Linux/Unix OS.

Store the full date in a variable and when you need the year use YEAR( your variable ). Everywhere you needed to use your year variable you can use the formula to get the year from your date variable.

Hi, By "export" you mean save the file on the filesystem? If that's the "export" you look for you are right looking in the EJB direction, OBIEE itself can schedule execution of analysis with agents, but an agent generally deliver a notification on screen (in the OBIEE home or where you add the right view in your…

user4580579 wrote:There's a lot of Data Filters on it and I would like to copy that filters in any way. Hi, So do you want to duplicate a role and all the permissions / data filters setup on it? So if in the RPD you defined 50 rules on 50 different dimensions on app role BiConsumer you want to be able to create an app role…

Hi, As you saw by yourself when you select the "calendar" view (user input = calendar for the prompted column) you lose many of the standard feature. One of the things you lose is to be able to limit / reduce the list of possible values by setting a start/end date or, like in your case, a year. There isn't a way to do it:…

Of course AGO will work. Forget about the name "time series functions", they don't need a real date at all ... The AGO function will use the chronological key you define on your levels of the time hierarchy to move forward or backward by calculating how many elements it's navigating (it's really done by counting number of…

Hi, The "time hierarchy" is just a normal hierarchy with levels. No need to contains any real date/time field ... All you need is levels with columns that can be used a chronological keys. Often these will be the same as the logical level key, unique columns at that level that can be used for sorting and drills etc. So you…

Hi, 2714750 wrote:...but Essbase report is throwing error - a generic error message. Why not to post the "generic error message" ? Because there are hundreds of "generic error messages" in OBIEE / Essbase. Did you checked the logs for the generated MDX? Is it a valid MDX? In general I would say that for Essbase you better…