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…

If you look at the certification matrix you will see that Windows 8.1 is definitely not a supported OS for OBIEE 12c. The only component certified for that OS is the Admin tool. So if it doesn't work ... it isn't a surprise ... There is also some points about desktop OS or server OS, OBIEE 12c isn't really like Excel, so…

Hi, In 12.2.1.2.0 things changed a bit compared to 12.2.1.0.0, for example the catalog groups are gone now (they were there but deprecated in 12.2.1.0.0). In general it's recommended to move to authentication providers even if the doc still say the init block way is still there (Comparing the Oracle Business Intelligence…

Your files have the wrong name .... Gianni Ceresa wrote:... Did you double checked the extension is really .001, .002 etc. and not .001.zip but the .zip is hidden by Window? In your screenshot your files are visible as SampleAppv607p-appliance1.zip but look at the message of 7zip: SampleAppv607p-appliance1.zip.zip Put the…

Then that's strange ... If the 5 files are named correctly (.001, .002, .003, .004, .005) and checksum is valid by extracting .001 with 7zip you end up with the .ova file (the vm image). Did it many times (and not only me or the image wouldn't be online to download if not working). Do you have enough disk space? Maybe it…

Hi, Are your files all fine? Did you check the checksum? Did you double checked the extension is really .001, .002 etc. and not .001.zip but the .zip is hidden by Window?

Ok, but still ... the problem is that "put somewhere" a file is something that, luckily for all of us, isn't doable by a browser script. Imagine just a second if javascript would be able to write files in any random folder: the first time you visit a "friendly website" half of your files are overwritten by a javascript…