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…

Based on what you wrote I would say you look for the wrong thing in the wrong tool .... Your requirement isn't an OBIEE job, so let's get OBIEE out of the equation (it will only be a webpage hosting your button). Javascript is a client side language, so it's execute by your browser, therefor can't create a file somewhere…

Hi, The message "5.7.1 Client was not authenticated" is something your smtp server is telling you. Did it ever worked before? If yes and nobody changed the config get in touch with your SMTP admin to debug that. If you google that message you find many results related to Exchange. If you never used it before or it never…

ADB wrote:on my dashboard page i would like to create a button that triggers a javascript which is going to create a file in a certain folder. You maybe need to define a bit better your requirement ... Is the folder a folder on the OBIEE server or is the folder a folder on the workstation of the user using OBIEE ? In…

ORA-01722 is an Oracle error, not OBIEE, but your database. So without looking into details the message is about "invalid number" I would say you maybe have a mismatch between the Oracle database column type and the OBIEE definition in the RPD. A different type has been set by OBIEE or something around that. Take the…

Hi, Didn't you forgot to write most of your thread content? PS: the original thread was a lot less than now ...

Hi, Seem to be related to the java version. If you google "Unsupported major.minor version 52.0" you find many references explaining the case. Making it short you are trying to run a piece of java compiled with a version (1.8 I would say) but you run it with a lower java version.

Hi, Did you try "Tools" > "Utilities" > "Repository Documentation" and save as CSV ? You then open your file, delete the columns you don't need (ideally you are only interested in the first 3) and remove duplicates (so it will take you 2 clicks in Excel).