That is exactly what everyone has been saying. SampleApp is self contained, you install the virtual machine and then you import the SampleApp OBIEE files into it.

Follow the instructions in the deployment guide

Do you have any hard coded filters in your analysis on the columns that are included in the hidden prompts? Remove them if you have them and it should work.

Your question wasn't clear. Do you want to upgrade OBIEE in the SampleApp v607 VM? Is that what you mean? If that is what you mean then just download the software and perform the inplace upgrade.

Yes, as long as your server has sufficient resources to manage both instances. The Sample App is a self contained VM so it will not install anything "directly" on your server just within the VM.

Hi @Thomas Dodds shouldn't that be: New column formula = SUM("Fact - SCM AP Spend Summary"."Converted Amount" BY "GL Period"."Period Year" ,"SCM Vendor Mapping"."Revised Vendor Name") The list of dimensions to partition the fact are comma separated and yes, I do agree totally with you that this should be deployed in the…

I guarantee that the "how to ask a question correctly on a forum" guys will be adding one or 2 replies to this thread! Have you tried changing the name using the properties by right clicking on the SA and selecting properties?

What is the difference between the Order Detail and Order Summary facts apart from the grain? If it is just the grain then you can create a logical Orders fact table using both physical facts as Logical Table sources. The BI server will know which Logical Table sources to use if you set up the content level properly for…

What version of java have you got? Have you tried checking using java -version on the command line? Have you checked the logs files mentioned in the screenshot? Is Java correctly set up in the PATH and JAVA_HOME environment variables?

What you are trying to do is standard OBIEE OOTB functionality so I'd strongly suggest that you take a look at some of the OBIEE tutorials especially this one: https://apexapps.oracle.com/pls/apex/f?p=44785:24:0:::24:P24_CONTENT_ID,P24_PREV_PAGE:12164,1 

Did you remove the BISystemUser? https://docs.oracle.com/middleware/1221/core/BIMIG/GUID-FD5B6C4B-1C0E-4EF7-BFA5-D401B83FC477.htm#BIMIG-GUID-FD5B6C4B-1C0E-4EF7-BFA5-D401B83FC477

Not much difference if any at all as both are pushed down to underlying data source by BI Server. The benefits are probably that you have more control with code in the rpd as opposed to code in the DB.

that's a "fact"

It's a self contained virtual machine with everything installed and ready for you. All you have to do is to download the files and follow the straightforward instructions to get it all up and running.

In that case as it is solely for learning the tool, why don't you get hold of an OBIEE virtual machine. OBIEE Samples

A few questions for you: have you looked at the compatibility matri - http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls Are you running 32. bit or 64 bit? Another more fundamental question is why are you installing this on a laptop and not on a server? Also why such an old version of OBIEE?

In your time dimension, if you have a column which indicates that the date is a month end, then you can quite simply apply a filter in your report to return facts for month end dates only.

How do you reference your connection pool in you DDR? Do you qualify it with the database name as defined in the physical layer? for example: "database name"."connection pool"

If you import your table into physical layer for test purposes, can you update the table count or select from it?

Hi Miguel i meant whether you could make a SQL*Plus connection from your OBIEE server to your database.