Friday, July 15, 2011

OBIEE11g Exposing the Metadata Dictionary

You might have seen a couple of these on the net the last couple of days. So I thought I will give it a shot also. Problem was I couldn’t get it to work, which was driving me nuts….. Thanks to Paul from http://total-bi.com for leading me trough this temporary period of insanity Knipogende emoticon 

Ok here we go:

Start with a new folder on you file system called OBIEE_META:

image

copy the WEB-INF folder from the analyticsRes into this folder:

image

open the current active rpd offline in the administration tool: (this is the one ending with the highest _BI00xx number!)

image

goto tools > utilities

image

select Generate Metadata Dictionary:

image

Browse to the OBIEE_META folder

image

image

close the administration tool.

Check the OBIEE_META folder

image

!! sometimes the administration tool adds an .rpd extension to the folder, if so remove it !!

image

next open your weblogic console:

image

press the lock & edit button, go to deployments:

image

select install.

image

Enter the OBIEE_META folder location, press next

image

Select Install this deployment as an application, press next

image

Select the bi_cluster as deployment target, press next

image

Select I will make the deployment accessible from the following location, press next.

image

press finish.

image

press activate changes

image

go to the deployment screen and locate OBIEE_META.

image

start the application.

image

check the status:

image

open the instanceconfig.xml in an editor, add the following:

<!-- My Custom Stuff  Metadata Dictionary—>

<SubjectAreaMetadata>
   <DictionaryURLPrefix>http://localhost:9704/OBIEE_META/</DictionaryURLPrefix> 
<!-- replace localhost with the actual hostname –>

</SubjectAreaMetadata>

just above the </ServerInstance> tag

image

Open your enteprise manage en restart the presentation server:

image

Log in to analytics and create a new request:

image

don’t panic if the dictionary symbol isn’t enabled, you have to click on the subject area first!

image

Click on the symbol

image

Till Next Time

2 comments:

Anonymous said...

Hi

I read this post two times.

I like it so much, please try to keep posting.

Let me introduce other material that may be good for our community.

Source: Business starting guide

Best regards
Henry

Sai Prakash K said...

Thanks, I always love hearing from new readers. I’ll be resuming posting this weekend, so keep an eye out .
Business Dictionary