[OBIEE 11g] Trellis View

 

OBIEE11g - Trellis View

In terms of visualisations is Trellis Charts; these are “grids of charts” that display matrices of measures with each cell in the matrix containing a micro chart, showing for example sales in each territory and product category graphed over time. Trellis Charts are available for all installations of OBIEE 11.1.1.6.2 BP1, not just Exalytics-enabled ones, but as we’ll see in a moment they’re best suited to Exalytics environments. Simple Trellis Charts, as shown in the screenshot below, allow you to select a particular graph type for each trellis chart cell, with in the example below each cell in the trellis showing sales broken-down by product category.

Find Bellow steps:

1.Create a new analysis by selecting New>Analysis on the global header, and then selecting A-Sample Sales as the subject area.

2.Select Column from criteria tab.

3.Click the Results tab. Two views Title and Table appear.

4. Add the Trellis view. Select New View>Trellis>Simple.

5. Save the analysis as My Trellis View, under the folder My Folders/Regional Revenue.

 

6. Click the Edit View pencil iconin the Trellis view at the Compound Layout. Note that the layout pane appears vertical.

7.Arrange the dimensions and measure as shown below:

8.Click Done.

9.The Trellis view appears. Save the analysis. Observe that the measure has the same scale for all the Brands.

Finally See the result.. 

[OBIEE 11g] Creating An Agent In OBIEE 11g

Creating An Agent in OBIEE 11g

In OBIEE 11g all the tables related to scheduler services are preconfigured. When we are installing OBIEE 11g, we are running repository creation utility (RCU).

RCU is creating two schema called Metadata schema (MDS) and BIPLATFORM. All the scheduler related tables were created in BIPLATFORM schema. So Enterprise Manager (EM) is taking these schemas automatically and running scheduler services in BI 11g.

Connect with BIPLATFORM schema in the data source. There we can view the scheduler related tables S_NQ_JOB, S_NQ_INSTANCE, S_NQ_JOB_PARAM, S_NQ_ERR_MSG which are created already when we were running RCU.

So if we are opening the Job Manager, we will not get any option ‘Open Scheduler Configuration’ like OBIEE 10g. We will get the screen like below:

By Selecting ‘Open Scheduler Connection’ we will get the window like below

We have to give Administrator username and password of the RPD. And click OK button you will get Job Manager Window there we can see the current running Agents. 

If you want see the configuration window Login in EM using below line

http://machinename:7001/em 

Go to Business Intelligence -> Core Application Select Deployment tab -> Select Scheduler there we can see the database has been pre-configured.

If we want to send the created Agent to Email then there is small workaround to be needed.

In the same above window select Mail tab under Deployment tab. There we have to give SMTP server port number and from which Email address we want to send.
After you entered all the details in the fields we have to Activate Changes and restart the BI Services.

Now we can login into the presentation services and select New -> Agent. 

All other steps are same like OBIEE 10g in each tab. 

[OBIEE 11g] Displaying External Documents On An OBIEE Dashboard

Displaying External Documents on an OBIEE Dashboard

To host externally-generated PDF reports in OBIEE and have them display alongside their other OBI content. They also wanted these files to be searchable by name like the rest of elements comprising the web catalog. To achieve this requires a few steps and a bit of trickery to expose one of OBIEE’s internal urls. Here we go…

Firstly create a folder to  the external files. Navigate to ‘Catalog’, click the ‘New’ dropdown menu icon and choose ‘Folder’.

Enter the desired name of your folder.

With the new folder highlighted in the right pane of the Catalog manager, an option for ‘Upload’ appears in the bottom left hand Tasks area. This is how we get the external files into the web catalog.

Now to get the files to appear on a dashboard page. For this you can either add an ‘Action Link’ object to your page or – as I’ve done here – a ‘Link or Image’ object. Drag this from the left hand side of the screen in the usual way.

Edit the properties. Enter some text in the caption field – this becomes the link text. Select the URL radio button and now you’re ready to enter the URL. Here we use Presentation Services’ internal mechanism for presenting files for download. It requires that you translate the path to your file to url encode all the special characters. The format for my example is:

http://server-name:9704/analytics/saw.dll?downloadFile&path=%2Fshared%2FPDFs%2FFilename.pdf

Note that I also added a url to a pdf icon in the image box and set it to show to the left of the caption.

[OBIEE 11g] Presentation Variable To Prompts In 11g

  

Presentation variable to prompts in 11g

When we are using Presentation variables, Prompt functionality is very limited. One of those is using option 'All Column Values'.Here I'm trying to depict a Tip to make use of option 'All Column Values'.To demonstrate the same here I'm defining a Presentation variable as '' using Page or Dashboard Prompt.

When I select 'All Column Values' we see the report with 'No Results' message as shown below since the criteria is not set properly

Use the below case statement to so that the condition matches as shown in the image

<COLUMN> LIKE (CASE WHEN '@{U}{}'='' THEN '%%' ELSE '@{U}' END)

On the Dashboard page, the prompt with option 'All Column Values' is selected and the report results are as below