RSS

Tag Archives: presentation services

How to Clear the query cache in OBIEE11G Presentation Server?

When users run analyses, Presentation Services can cache the results of those analyses. Presentation Services determines if subsequent analyses can use cached results. If the cache can be shared, then subsequent analyses are not stored.

The files for the Presentation Services cache have names such as nQS_xxxx_x_xxxxxx.TMP. The files are created by the ODBC driver but generally do correspond to ODBC requests that the Presentation Services cache keeps open. The files are stored in the following directory:

ORACLEBI_INSTANCE\tmp\OracleBIPresentationServices\coreapplication_obipsn\obis_temp

The files for the cache are removed whenever Presentation Services shuts down cleanly. If Presentation Services shuts down unexpectedly, then various cache files might be left on disk. You can delete the files when Presentation Services is not running.

The Presentation Services cache is not the same cache that is accessed by the Oracle BI Server.

Sometimes we may need to clear the Presentation server cache also, to clear that follow the below steps:

  • OBIEE 11G has a catalog manager command called “ClearQueryCache” to clear out the PS cache.
  • The syntax of ClearQueryCache command is: 
    runcat.cmd/runcat.sh -cmd clearQueryCache  -online <OBIPS URL> -credentials <credentials properties file>
  • Create a catalog manager credential properties file. Open a text file and type the following entries.
              Login = <weblogic_admin_Username>
              Pwd = <weblogic_Admin_Userpassword>  
    And save in a directory with the file name as catmancredentials.properties.
  • Now open command prompt and navigate to <MW_HOME>instances\instance1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\catalogmanager\
  • And Run the following command to clear OBIPS query cache:
    runcat.cmd -cmd clearQueryCache -online http://shiva-pc:9704/analytics/saw.dll -credentials E:\catmancredentials.properties

OBIPS_Cache_Clear

Thanks,
Shiva

 
 

Tags: , , , , , , , , , ,

SmartView – OBIEE 11G Integration: Create Reports from Excel and save in OBIEE catalog

Create an analysis in Excel using SmartView and save in OBIEE catalog

Using SmartView add-in, we can create OBIEE reports from Excel/Word and save in OBIEE catalog.And we can see those reports within OBI Presentation services and can use it for further analysis.

To create an OBIEE report from excel, follow these steps.

To create a new analysis from SmartView,  Open Excel and connect to Oracle BIEE.

Navigate to Oracle BI EE tab.

And then click on “View Designer” button.

SmartView_Integration_6

The View Designer button will open the Oracle BI EE presentation services Subject Areas. Expand the Subject Areas of your choice and drag the columns of analysis into the areas of report layout.

The SmartView has variety of View types, for demonstration purpose I am using Pivot table.

The Available Report View types are:

SmartView_Integration_7

In my example I am creating a pivot table, so dragged the Order type in Rows, Order Status in Columns, and Revenue in Measure block. And I am grouping the result set by year, so moved the Per Name Year in Section part.

SmartView_Integration_8

The wizard will generate a report like this in Spreadsheet:

SmartView_Integration_9

Now to save this report in OBIEE catalog, click on publish View button.

SmartView_Integration_10

It will open the OBIEE catalog folders. You can save the report into a folder of your choice that created in OBIEE catalog.

SmartView_Integration_11

Select the Folder in OBIEE catalog and give a name to report and click save.

SmartView_Integration_12

SmartView_Integration_13

Now the report is saved in OBIEE catalog like the analysis we normally save in OBIEE Catalog:

SmartView_Integration_14

See how the report is rendered in OBIEE Presentation services.

SmartView_Integration_15

There are many scenarios where we could use this powerful SmartView Add-in for a great flexible usage of OBIEE reports.

Thanks,
Shiva

 
5 Comments

Posted by on April 18, 2013 in BI Publisher, OBI EE, OBIEE 11g, Weblogic

 

Tags: , , , , , , , , , , , , , , , , , ,