Of course if you can have a SSD is nicer, but VMs doesn't require a SSD, your issues will more be RAM/CPU than the disk (as long as you are not using a USB2 drive). So not mandatory, as Thomas said he is perfectly living without for his VMs

Good you found it, so just in case somebody else look for it it's in the properties of the chart view when customizing the axis labels.

Minimum 16Gb of RAM if you don't want to die ... Disk space I guess the image needs a bit more of 60Gb (more when extracting as there is the OVA etc.) Of course, being a server app, the more the better (for RAM, CPU etc.)

Just add/remove 180 to the orientation, if it is 90 set -90 or if it's -90 set 90. So you read bottom-up instead of top-down...

which version of Firefox? which other browser (and version) you tested? Because it seems to be something related to the browser as the chart is there, goes away and come back when you refresh...

Would be helpful if you provide basic information like which version of OBIEE, browser you used and which other you tested.

Robert already said it, also maybe a screenshot will help to clearly see what you see when and where

Use CURRENT_DATE and all the existing OBIEE functions on dates to generate the required filter based on your data (depends how you need the filter to look like, if "Feb 2017" or "201702" or 2017-02-28 as a date etc.). A filter in an analysis is not just a static value, you can add functions etc.

Welcome to the world of IT .... Integer division, that's what you are seeing, so 0 is the right result. You must force the division to use a double type doing a cast of at least one of the element of the division. (OBIEE - Integer Datatype [Gerardnico] ) You can also use a pivot view and duplicating the column in the view…

Hi, I don't see where is the issue ... Row numbering is done at the query level, a visual reordering in the front end is not supposed to change that. If you make a SQL query with a row number column, export to Excel and sort by another column of your data set does the row numbering column change? Not really ... So it works…

Even without cache you have temporary internal caches that are still there, but it's not a real storage, more like an operational storage (like an app creating tmp files while running etc.). If you schedule an analysis with an agent? The output of the analysis is sent out based on your config. As data flow through OBIEE in…

@Amol Palkar : define your join in the physical layer as Christian showed, if you already have an existing join like columnA = columnB delete it first as you can't change it on the fly (it's because of 2 different kind if join: "physical foreign key" vs "complex join"). In the formula window you see you have lot of…

You can relate it with data but you have to "translate" the kpi OSSM references into data yourself, it's not a simple A = B relation with what is stored in the DB table.

Can you please close the thread? (I guess "assumed answered" is the best matching as the answer is that you asked something else ...)

Good for you Can you mark yours (the one about SR > Oracle > patch) as the answer and close the thread? It will help others with the same issue. For now it's still This question is Not Answered.

Thanks, make sense (the "increase factor by" was the mysterious part ). I still believe there is no need to disturb LAG / LEAD. You can get the value of the previous row for your calculation by using MSUM() and some logic. MSUM("your column", 2) - "your column" = the value of the previous row of "your column" You now have…

For that you generally set a count (or count distinct) aggregation on the ID (PK) column of your data. Don't you have an ID or don't you want to use it? You can also try by creating a column as "derived from physical mapping" and in the formula of the column you set 1, you then add an aggreation of SUM on it.

I guess the same but as he blurred a lot I'm not going to guess more and wait for his answer

Christian already gave you a big piece of the answer. I personally wouldn't disturb analytic functions of your DB because 1) you maybe don't have an Oracle database as source and so LEAD/LAG are useless and 2) there are still ways to do it in OBIEE ... What makes one row different from the other? What define the order of…

So that's not a "the OBIEE sample app", it's just OBIEE, nothing to do with the sample app at all. (The default content you can decide to deploy during the configuration is sample app lite, a bunch of reports based on XML sources).