Pivot Table and its properties in OBIEE 11g and 12C

Differences between OBIEE 1g and 12c

Differences between OBIEE11g and 12c

OBIEE Mobile Dashboard Demo

Following video shows you OBIEE Mobile dashboard demo

Starting and Stopping OBIEE Services from Putty

Sometimes even though we stop all the weblogic processes still node manager/obiee services will be running in the background.

To make sure no other process is running kill nodemanager and obiee processes

ps -ef |grep Node|grep nodemanager |cut -c10-15

ps -ef |grep obiee

Kill the above processes ( kill <PID>)

Stopping Weblogic

Go to

<OBIEE Home>/user_projects/domains/bifoundation_domain/bin/

Then run -> ./stopWebLogic.sh

Starting Weblogic

---------------

nohup sh

<OBIEE Home>/user_projects/domains/bifoundation_domain/bin/startWebLogic.sh -Dweblogic.management.username=weblogic -Dweblogic.management.password=weblogic234 > wls_start.log &

Note: Change password of your application. Nohup is the command to run the process in the linux and give the control back to putty.

Starting NodeManager

------------------

nohup sh  <OBIEE Home>/wlserver_10.3/server/bin/startNodeManager.sh > startNodeManager.log &

Starting EM

------------

nohup sh <OBIEE Home>/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1

Note: bi_server1 is the server name. make sure your server name given properly

Starting OPMN

----------

cd <OBIEE HOME>/instances/instance1/bin/

./opmnctl startall

./opmnctl status   -- To Check the Status

OBIEE - Session Variables are not updated problem

OBIEE - Session Variables are not updated problem

When you are using Session Variables, with Row-wise initialization.

In case you have a problem with those session variables not being updated, unless you restart the BI server...

Please make sure that the "use caching" option is turned off. Otherwise the Session Variables are not refreshed each time you log in.

(The use caching is very useful in many other cases).

How to Increase no of rows in excel output in OBIEE

To use Fusion Middleware Control to set configuration options for views:

Go to the Business Intelligence Overview page, as described in Section 2.2.3, "Using Fusion Middleware Control to Manage Oracle Business Intelligence System Components."

Display the Performance tab of the Capacity Management page.

Click Lock and Edit Configuration to enable changes to be made.

Complete the elements using the descriptions in the help topic for the page. Click the Help button on the page to access the page-level help for the following options:

Maximum Number of Rows to Download option
Maximum Number of Rows Per Page to Include option
Click Apply, then click Activate Changes.

Return to the Business Intelligence Overview page and click Restart.


Method 2:

To manually edit the settings that change the display of data in views:

Open the instanceconfig.xml file for editing, as described in Section 3.6, "Where Are Configuration Files Located?"

Locate the Table, Pivot, Trellis, Charts, Narrative, Ticker, and Treemap parent sections, in which you must add the elements that are described in Table 19-2.

Include the elements and their ancestor elements as appropriate, as shown in the following example:

<ServerInstance>
  <Views>
      <Table>
        <MaxCells>10000</MaxCells>
        <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>500</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
        <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
        <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
        <DefaultRowsDisplayedInDownloadCSV>65000</DefaultRowsDisplayedInDownloadCSV>
      </Table>
      <Pivot>
        <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
        <MaxVisibleColumns>300</MaxVisibleColumns>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>500</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
        <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
        <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
        <DefaultRowsDisplayedInDownloadCSV>65000</DefaultRowsDisplayedInDownloadCSV>
      </Pivot>
      <Trellis>
        <Simple>
            <MaxCells>1000</MaxCells>
            <MaxVisibleSections>10</MaxVisibleSections>
            <MaxVisiblePages>1000</MaxVisiblePages>
            <MaxVisibleRows>100</MaxVisibleRows>
            <MaxVisibleColumns>75</MaxVisibleColumns>
            <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
            <DefaultRowsDisplayed>10</DefaultRowsDisplayed>
            <DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>
            <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
        </Simple>
        <Advanced>
            <MaxCells>5000</MaxCells>
            <MaxVisibleSections>50</MaxVisibleSections>
            <MaxVisiblePages>1000</MaxVisiblePages>
            <MaxVisibleRows>250</MaxVisibleRows>
            <MaxVisibleColumns>150</MaxVisibleColumns>
            <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
            <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
            <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
            <DefaultRowsDisplayedInDownload>10000</DefaultRowsDisplayedInDownload>
        </Advanced>
      </Trellis>
      <Charts>
        <MaxVisibleColumns>2000</MaxVisibleColumns>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>2000</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
      </Charts>
      <Narrative>
        <MaxRecords>40000</MaxRecords>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
      </Narrative>
      <Ticker>
        <MaxRecords>40000</MaxRecords>
      </Ticker>
      <Treemap>
        <MaxCells>5000</MaxCells>
        <MaxVisiblePages>10000</MaxVisiblePages>
        <MaxVisibleRows>10000</MaxVisibleRows>
        <MaxVisibleSections>50</MaxVisibleSections>
      </Treemap>
  </Views>
</ServerInstance>
Note that this example does not include elements that might exist in the file, but that are centrally managed by Fusion Middleware Control and cannot be changed manually.

Save your changes and close the file.

Restart Oracle Business Intelligence.

Merged Columns in excel output in OBIEE

1. Take a back up copy of <Middleware_Home>/instances/instance1/config/OracleBIJavaHostComponent/coreapplication_obijh1/xdo.cfg file.

2. Open xdo.cfg for editing.

3. Add the following:
(Setting "xlsx-keep-values-in-same-column" to true)

<config version="1.0.0" xmlns="http://xmlns.oracle.com/oxp/config/">
<properties>
<property name="xlsx-keep-values-in-same-column">true</property>
</properties>
</config>

4. Save your changes.

5. Restart all OBIEE components. Make sure you restart bi_server from weblogic as well.

For Cluster environment change the above file in both the instance and then restart