Monthly Archives: April 2009

Renaming Dashboards in OBIEE

Standard

Renaming Dashboards in OBIEE

There are 2 ways to rename the shared dashboards.

1. Using Catalog Manager
2. From Answers admin tab.

Using Catalog Manager:

1. Log in to catalog manager and navigate on shared folders and select the Group Folder under which you have created that dashboard.
2. Navigate till you find _Portal folder under the shared folders

_portal-path

 3.   Select a dashboard that you want rename from the right side pane, right click and select Smart Rename (fix refs) option

renaming-dashboard

4.   Here you give your desired name for the selected dashboard.

            I am renaming it to Rename Test

rename-dashboard

     5. Press Enter to submit the name to server

     6.  Now go to login to presentation service and go to dashboards. You will see that your dashboard name has been changed.

verify-dashboard-name

Rename dashboard from Answers admin tab:

 

  1. Log into presentation service with Administrator, go to Settings > Administration > Manage Presentation Catalog.
  2. It opens a window; in this window you find option Show Hidden Items. Select this check box. Now you are able to
  3. Navigate to the Shared Folders and the group folder under which you have created the dashboard.
  4. Select _Portal folder (this will only appear when you select Show Hidden Items options)
  5. It displays the list of dashboards under this folder. Now select Rename option corresponding to the dashboard that you want to rename

manage-catalog

      6.   Here you mention the desired name and click on Update.

update-name

    7.   Now go to Dashboards and check whether name has renamed or not.

 

 

Setting LOGLEVEL from Answers

Standard

Normally, we check query in NQQuery.log file or from Answers also we can check the query directly.

 Difference is: NQQuery.log contains all the queries and need to identify them by time the report run.

If it’s directly from Answers (go to Settings > Administration > Manage Sessions), log available for every report runs until the query is changed.

 For every query of report there will be created one cursor, by accessing the cursor you can see the physical query generated by BI server.

 If we are unable to see the log file or if we find any error message saying that, No Log found while trying to watch the query in log the first step in the mind is to check the LOGLEVEL. When creating rpd by default, loglevel takes 0 values for Administrator user.

If it’s set to 0, we go for 2 or 3 accordingly, such that, the query will be appeared.

For suppose, if you are accessing presentation service of another system and unable to see the query. You need not to set the LOGLEVEL=2 in the rpd presented in another system.

I am assuming that all cursors are closed and LOGLEVEL is zero for particular user.

Log into answers with user who has LOGLEVEL =0, run any report then go to Settings > Administration > Manage Sessions. Click on View Log option.

You will have error message or you may open the view log but you can’t find the query run at this moment because of loglevel – “0”. (To test this error message, you better delete the content of NQQuery.log completely but before doing this you need to stop your BI Server service then clear the content and save file again start BI Server service)

error-message

Close the window as well as cursors

 Just go to advanced tab of particular report.

advanced-tab

Scroll down to see the option: Prefix

Here write SET VARIABLE LOGLEVEL=2; (semi-colon at the end is must)

 prefix

Now click on Results tab to re – run the report.

 Now you go Settings > Administration > Manage Sessions

Click on View Log to view the query. Now you are able to see the query and according to the LOGLEVEL – 2

 Go back to Advanced tab, observe the Logical query.

Before SQL, you find the text you written in Prefix field.

By mentioning the semi colon, BI Server executes these statements one after another.

This post explain you, how to set loglevel from answers it self, with out going to rpd,

This process overrides the loglevel set in the rpd.

Hello world!

Standard

Hi.. This blog is operated by Kishore Guggilla and Naresh Meda. We are colleagues and working as BI Developers. Here we want to share our ideas and researches. We were the active members of OTN Forums and inspired with Venkat and John’s blog. We may not reach to that level, but we brings up all our ideas and research work we done. All the views expressed here are our own and does not reflect the views of our employers. We need all your blessings and support to grow. Thanks