Saturday, November 15, 2008

Column Header Tooltip (mouse over) in OBIEE

You can set Tooltip/mouse over functionality over column header of the table. you can add HTML tag within column header. steps are -
1. Go to column format and check custom heading
2. add html tag like {b title="My Tooltip"}My Column Header{/b}
3. Go to instanceconfig.xml
4. Edit it and add tag - {HardenXSS}false {/HardenXSS}
//change { with less than and } with greater than sign
5. Restart the services.


Regards,
Devendra Chhajlani

Thursday, September 18, 2008

Dashboard within Dashboard

For Creating Dashboard within Dashboard you need to create one folder e.g. (Sales or any name) within shared folder.

When you add new Dashboard that should be create within Selected Group folder e.g. (Sales Analysis)


After adding below tag in instanceconfig.xml, it will show group folder wise dashboards in Menu,
(Dashboards should be more then DashboardMaxBeforeMenu values)


Thanks

Santosh


To solve the problem of Prompts (Too many values)

After adding below tag in instanceconfig.xml, prompt will show all values.

You can change MaxDropDownValues value as per requirement
Thanks
Santosh

BI Practice: Admin Tab Not Appearing in BI Publisher

BI Practice: Admin Tab Not Appearing in BI Publisher

Admin Tab Not Appearing in BI Publisher

Admin Tab Not Appearing in BI Publisher

Admin tab not appearing after login through Administrator/Administrator in BI publisher (this issue raises only when you are using your own repository, not demo/paint repository).

To solve this issue you have add one security group in your repository named as XMLP_ADMIN.

After this assign Administrator User to this Group i.e. Administrator user member of 2 groups 1.Administrators and 2. XMLP_ADMIN

Now bounce the services OracleBI Server, OracleBI Presentation Server and OC4J.
Now login into BI Publisher and see Admin tab is available, now you can perform Administrative tasks …...
Version of OBIEE 10.1.3.3, BI Publisher 10.1.3.3

Thanks & Regards,

Yashdeep Sant

Tuesday, September 16, 2008

Create prompt for Months using 'is Between' Operator


Often user wants to create prompt for Month and it should display like 'Sep 2008','Oct 2008'
But what happens if you also want to apply 'is between' operator ?

Because you can't apply 'is between' operator on month that have varchartype. Therefore, how can sql take care of 'between' clause on Varchar datatype .

But you can achieve this functionality using two month prompt and presentation variable.

- Create two month prompt          (like Current_Month and End_Month )
- Add presentation variable on both prompt   ( VarCurrMonth and VarLastMonth)




-  Create another report in answer that includes below columns :
  • Calendar Month
  • MIN( RMIN(Calender Date))
  • MAX( RMAX(Calender Date))
apply filter on Calendar Month using "OR" operation and Presentation Variable

- Save Report in your Shared Folder with name like - "Month between another request" report
-Go to your main report that contains date column and Apply filter using 'Based on another   request' functionality. then select "Month between another request" and set column filter twice as below :
  •   First for Greater than or equal to MIN( RMIN(Calender Date))
  •   Second for Less than or equal to MAX( RMAX(Calender Date))



Cheers !!!!!!!!!!!!!


Regards,
Devendra Chhajlani

How to achieve Show-Hide functionality in BI Publisher Report?

How to achieve Show-Hide (Collapse-Expandable) functionality in BI Publisher Report?

If anyone wants to achieve Show-Hide functionality in the BI Publisher report, for that we require master – detail form report like Invoice and Invoice Details, such report shows the Invoice and products detail in that invoice.

Example: Now, How to achieve this in BI Publisher report? For this we need to add some dhtml tags in the template of report (RTF), this functionality works well in HTML format only, and required version of BI Publisher is 10.1.3.3

Developers have to add form fields and use the following DHTML tags :
Thanks & Regards,
Yashdeep Sant

Monday, September 15, 2008

How to remove "My Dashboard" tab from dashboard

select the path OracleBI\web\msgdb\l_en\messages
copy the file uimessages.xml.

create a folder customMessages in
OracleBI\web\msgdb\l_en

place the file uimessages.xml in it.
edit it and remove "My Dashboard" tag.

Regards,
Vinay Porwal

BI Publisher Menu in MS Word

Go to login on BI publisher using Administrator user
then click on "Template Bulider" from left pane. it will download
"BIpublisherdesktop.exe" .

After completion of download just execute it and follow the instructions then u will able to see Oracle BI Publisher menu in ms-word.


Regards,
Devendra Chhajlani

Conditional formatting in pivot table:

I want to do conditional formatting on some columns
based on another column:

The requirement is, suppose a table having columns:

Country|Product|Amount
A Y 10k
B Z 30k
C X 20k
. . .
. . .

The rows should show in RGB color based on amount figure.
It is possible in table view to do conditional formatting
as
create another column apply the case
using max and min on amount then
three status we will get as 'max','min' and 'other'.Use this status
in other columns for conditional formating.

Hence we are able to do conditional formatting in this way in table view.
But the problem is if we take pivot table view of this, then we
r not able to get conditional formating in it.

Is their any way to achieve this in pivot table?

Thanx

Regards,
Vinay Porwal

Show selected Timeperiod in Narrative View without using Variables

If you have date prompt and want to apply "between" operator then you can't store selected values in presentation variable.
but We can show selected date range in narrative view without using presentation variable.
Resolving the issued we need to do following steps -

  • add two more columns on report.
1. RMIN(FROM DATE) /* From Date can any date column */
2. MAX(RMAX(FROM DATE)) /* For "TO DATE" */
(bcoz only "FROM DATE" prompt will appear for two date values)


  • Use both columns in narrative view with appropriate column sequence number.

but one problem here is that if your result doesn't contain records as per your input then it will give only available Min and Max date.

Regards,
Devendra Chhajlani

Unable to login into BI Publisher

Try with

user : Administrator
pwd : Administrator

Update / Change repository password as 'Administrator'

if still you are not able to log in. Create one group 'XMLP_ADMIN' into repository and map Administrator into XMLP_ADMIN group.

thanks,
Pradeep