Well, to become familiar with OBIEE the VM only works for half the work, and it would be the same half as the public demo instance that exist (it was linked somewhere on the official site, can't remember where). The VM, just like the demo OAC instance, will let you get familiar with the front end. For the backend, the RPD…

VBoxManage is a command coming with VirtualBox, go in the folder where VirtualBox is installed to find it (it's probably not into your path and therefore not visible without a full path). Also, because you are on Windows it's probably going to be VBoxManage.exe All the links inside the VM only works if the VM knows how to…

https://community.oracle.com/tech/apps-infra/discussion/comment/16823646 It has the required command (VBoxManage) you need to be able to fully switch off time sync, set the VM to a date in 2017 or 2018 (the VM has been released in 2016).

The VM is very old (too old), all the internal SSL certificates are expired by now. You need to turn off time synchronization and change the VM date back in the past. There is another thread in here covering exactly that, let me see if I can find it.

You can create BAR files by command line and schedule that. The front-end snapshop doesn't have a scheduler.

I did a "next next next" kind of import, didn't change anything and only clicked through the screen accepting what I had to accept.

SHA1 hash of SampleAppv607p-appliance.ova: 2c9ec1d27cd0a5352668c8dda4fd91221c6b2b2f MD5 hash of SampleAppv607p-appliance.ova: db035344497c3c8360948ee4b54e8297 My OVA has the same size as yours, so check the checksum to see if it's the same and that would confirm the OVA is fine. It imported fine in my VirtualBox 6.1 in…

The file size is correct, so in theory the file is fine. I just run an import on Virtualbox 6.1 to see if things work differently today than years ago when it has been released...

Can't you find some extra logs somewhere? (a log file or whatever) That error seem to be quite generic. How big is your OVA file? (just checking if all the parts were extracted fully)

Your files have the wrong names, rename them to have the currect file names and problem will be solved. Is your Windows showing you the file extension of files? Because you maybe believe you did rename files to be <something>.zip.001 , .002, .003 etc. While in reality they are still .001.zip etc. By default Windows DO NOT…

Have a look at the time series calculation functions, for example AGO(...) will let you access the previous month measure value. The concept of "previous record" is very vague as a previous record always depend on the sorting applied to your analysis, so I would try to stick with something more defined like "previous…

You can't see any filter section because it's a DDR: you wrote a SQL query, you want to filter it? Add a WHERE condition to your query. You can reference existing variables with the usual OBIEE/OAS syntax, for example @{variable_name} .

Aggregation are an attribute of a logical column. If you create the 2 with their needed aggregation and then create a 3rd logical column being derived from the first two (something like col1 + col2) ? A derived logical column doesn't have a physical mapping, it has a formula based on other logical columns, therefore it…

You have Windows 10 Pro: why don't you use WSL for these things? It will at least be on a certified OS while still being "local". Oracle even released Oracle Linux 7 and 8 in the Windows Store, all you have to do is do your installs.

What did you try so far? Because if you tried, you definitely had it right after few attempts... LOCATE tells you where the ',' is in your string, then you need to take what is on the left and on the right. For the XXX part, if you use LEFT() it's easier, because you can use the result of LOCATE() -1 to get the number of…

By the way, you were asking for BI Publisher in a MOSC forum, and now you posted this in a public forum with content of a MOS document: it's borderline with the rules, MOS documents content can't be posted in the public forum (because MOS documents are a resource you need to pay support to have access). If you have…

The syntax you posted isn't for BI Publisher but for an analysis in OBIEE. When you create an analysis you have various kind of visualizations (table, pivot, bar chart, pie chart etc.), one is called "narrative" and support the syntax you posted. It's a way to generate content with the result of the query of the analysis.…

Isn't there a TRIM function? Or maybe it's still split between left and right trim. Just find where the space come from (is it because of the year, the month or an implicit conversion from numbers to chars?).

You already found what is the reason: your 2 users have different roles. Take that role and explore what permissions & privileges it has. Some permissions are stronger than other, so having an additional role can explain that the user sees less things.

Was the date column you used with a display mask of YYYY-MM of a lower granularity than your Year or Month column? Because a display mask doesn't change the real value of a column: if it was at the day granularity, you probably have multiple days in your dataset for every year and month, and despite displaying only YYYY-MM…