ORACLE BUSINESS INTELLIGENCE WORLD

Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles





  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 337,410 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for September, 2014

OBIEE11g Footer/Header Pager Number Format X of Y Page Numbers

Posted by Santosh Kumar Gidadmani on September 28, 2014

By default the page number under print options header and footer is @{pageNumber}, which will provide Page X format but if you need Page X of Y Pages, you will need to use the below format.

@{pageNumber} of @{numberOfPages}

Pagenumber

Thanks,

Santosh

Advertisements

Posted in End User Analysis, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Dashboards | Leave a Comment »

OBIEE 11g Image Path

Posted by Santosh Kumar Gidadmani on September 27, 2014

If you want to place your own images in OBIEE reports and dashboards, you can place your images in two OBIEE 11g directories as below.

D:\OBIEE11g_HOME\user_projects\domains\bifoundation_domain\servers\AdminServer\tmp\_WL_user\analytics_11.1.1\silp1v\war\res\s_blafp\images

D:\OBIEE11g_HOME\Oracle_BI1\bifoundation\web\appv2\res\s_blafp\images

After placing the jpg image in the above directories, restart the services.

Use the below format to place the jpg images in reports.

Example:fmap:images/report_agreements.jpg

images

Thanks,

Santosh

Posted in End User Analysis, OBIEE 11g, OBIEE 11g Analysis, OBIEE 11g Dashboards, OBIEE 11g RPD, OBIEE11g Dashboard Pages | Leave a Comment »

OBIEE Database Type for Teradata Database

Posted by Santosh Kumar Gidadmani on September 21, 2014

If you import the physical schema into the physical layer, the database name and type are usually assigned automatically. However, if the OBIEE server cannot determine the database type, an approximate database type is assigned to the database object. If necessary, replace the database type with the closet matching entry from the database drop down list.

Example: When you import the data from Teradata Database (tables or views), by default the OBIEE database type will be V2R6 but the latest database type will be different. I have connected to Teadata Database version 14.10 the OBIEE database type should be V13 as shown in second screen shot below.

Default Database Type

OBIEE_Teradata1

If you keep the Teradata V2R6, you will get the database features warning during global consistency check (the features in database ‘Semantic Views’ do not match the defaults).

Change to V13

OBIEE_Teradata2

When we have the closet database type, you should not see any errors or warning messages on the database features.

 

Thanks,

Santosh

Posted in OBIEE 11g, OBIEE 11g Errors, OBIEE 11g Performance Tuning, OBIEE 11g RPD, OBIEE11g on Teradata Database | Leave a Comment »

 
%d bloggers like this: