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…

Why the physical query is different than the logical one? Because that's what you paid for when you bought the tool. I know this answer is not something you will like... OBIEE does generate queries for you, as you see you don't write physical SQL anywhere. You model things, you write logical queries (you did it clicking…

The connection isn't technically impacted, but what makes your OBIEE work is what makes almost any existing online resource not work: if you try to act like being 5 years ago, most sites or resources using SSL will have certificates that aren't valid (because too recent). You can turn on the date/time synchronization with…

If "grant total" is the automated totals you enable at the view level, the aggregation works in a single way for all the rows. If you use something like Essbase where you defined your accounts dimension, you can set aggregation rules for every account at any level of the hierarchy. If you don't have that kind of source,…

Ah, got it now. So your logic is something like: for a report run today you want to have the date of Friday of this week and the date for Friday a week ago. What happen if you run the report on a Tuesday? Do you still get the date of this week's Friday (so a date in the future)? Or do you want the date of the last 2…

https://community.oracle.com/tech/apps-infra/discussion/comment/16824476#Comment_16824476 Schema of what? OBIEE doesn't have any data, doesn't have any schema. If you expect a proper reply you should invest more than 10 seconds in asking the question. Put words to define what product you talk about, what version and what…

Reply to this thread, don't open a new one. If you "run your report" on January 7 you expect the "last two week" to be January 25 and February 7? What kind of calendar is that? How come that end of January and beginning of February are the "last two week data" for January 7?