Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
Not sure what your underlying database is but Oracle for example has LAG and LEAD Analytic functions so you can push this down to database by using the OBIEE EVALUATE function. http://gerardnico.com/weblog/2009/04/17/obiee-period-to-period-comparison-with-the-analytical-function-laglead/
-
SQL Server does support synonyms. As I mentioned earlier this is probably your easiest way of getting the BI Server to generate a single physical query and to hopefully make use of your indexes. Sent from my iPhone
-
In that case, you'll need to create a synonym in your database for one of these objects. This will allow both objects to be accessible from one database and therefore one connection pool. The BI Server will then be able to generate a single SQL statement.
-
As far as OBIEE's BI Server is concerned, these are 2 different data sources (that just happen to be on the same server in this instance) which could be 2 different databases on 2 different servers potentially. The BI Server is dealing with this by issuing 2 physical SQL queries and federating the results in memory. Why do…
-
Personal Folders are just that - they are only accessible to the owner. If you want to share content, then the Shared Folder structure should be utilized. You can set the permissions on the Shared Folder to ensure that it is only accessible to the correct audience.
-
I believe this is what @Christian Berg is referring to: SampleApp v607. You'll need the SampleApp VM to get hold of the actual scripts to see if they extend to your particular requirement.
-
That isn't possible I'm afraid. Think of the Measure Label as a column header in its own right.It isn't actually a data column so it can't have a column header in all fairness.
-
Could you check the log files of the specific agent? They might provide some additional information. You can access these logs which are in the same location as the scheduler log file or alternatively you can access them via Job Manager. By the way, does this happen for all Agents?
-
You only specify the join type (inner, left outer join, right outer join or full outer join) in the LTS and the actual join condition is defined in the physical layer.
-
It isn't compatible - http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-11-1-1-9-0-2541437.xls
-
As long as the user that the connection pool uses has access to the DB link then you should be able to use it. Sent from my iPhone
-
Has the OBIEE Cluster ever worked properly? You may need to check that you have setup the Cluster correctly.
-
Maybe OBIEE is not the right tool for you in that case. Take a look on Google for OBIEE and D3 Visualisations. Look at the previous thread: https://community.oracle.com/thread/3989597 Sent from my iPhone
-
This is a definition of Data Mashup that I pulled off Google - A data mashup is an integration of two or more data sets in a single graphical interface. A business dashboard is a prime example of a data mashup hard at work – most dashboards pull data from multiple, disparate sources to provide end-users with an at-a-glance…
-
You'll need to open up Visual Analyzer. You can access this on your OBIEE home page by clicking on the Visual Analyzer Projects link. Once you're in VA, you can add an Excel Data Source.
-
The error states an issue with loading the Presentation Catalog. Could you try loading the SampleApp catalog to rule out an issue with your upgraded catalog? By the way, did you follow the Catalog Upgrade pre-requisite steps - Slide 6 3rd bullet point?
-
I didn't realise that you installed OBIEE on Windows 10. This is not supported and this is why you're having these problems. You're best bet is to look at the certification matrix that Cesar provided and ensure that your hardware is certified to run OBIEE. Windows 10 is a Client OS and you're attempting to install…
-
As Cesar said, you need to ensure that your hardware and software versions are certified. You'll need to reinstall on certified hardware Sent from my iPhone
-
Didn't realise that this was a Windows 10 installation
-
As I said , in Admin Console, go to servers to check port that your BI Server (Managed Server) is running on and use that to log on to analytics