Tag Archives: OBIEE11g
OBIEE11g FireFox 10 problems
For those of you having problems with the new FireFox 10 client. Michal Novy posted a solution on Christians Blog:
Hi, I found the way how to do a workaround:
1. type "about:config" into an address bar
2. right click anywhere and choose New / String
3. name it "general.useragent.override"
4. put the value "Mozilla/5.0 (Windows; Windows NT 6.1; rv:10.0) Gecko/20100101 Firefox/9.0"
5. refresh OBIEE login screen
Then it works without any problems!
Seems that Oracle is already working on some patches: see patch # 13564003 released by Oracle Support which repairs this limitation.
Till Next Time
OBIEE11g SampleApp OID doesn’t start
Yep, I did again :-(.
After playing around with the new sampleapp107 I managed to crash the VM. After a reboot the OID refused to start up. It seemed that because there was still an active status record in the ODS schema, the OPMN couldn’t find anything to start.
Solution: truncate the "ODS"."ODS_PROCESS_STATUS" and "ODS"."ODS_GUARDIAN" tables in your database repository.
(Not sure if the "ODS"."ODS_GUARDIAN" is really necessary…. Please correct me if I’m wrong)
Till Next Time
OBIEE11g Aggregate At
One of the new feature of 11g is the AGGREGATE AT function. It uses the hierarchical level to pin the the aggregate. Problem is you can’t select a hierarchy level in the formula editor, so you have to some old school typing:
Example:
Only month 1 to 6 are selected.
Just like the BY statement you can do multiple levels from different Hierarchies:
Till Next Time
OBIEE11g Golden Rules: Catalog Management
First of al the original inspiration for these “Golden Rules” Series are based on the “20 GOLDEN RULES FOR REPOSITORY DESIGN” from the people at Peak Indicators. Kudos to them.
The series contains:
- RPD-Physical Layer
- RPD-Business Model Layer
- RPD-Presentation Layer
- Report Building
- Dashboard Building
- Catalog Management
The “rules” is this article are somewhat in random order
This is always a “work in progress” and please feel free to make any suggestions!
Catalog management
- use a transport folder.
Don’t allow all developers to place everything in all shared folders. Have them place it first in “transport” folder. Assign a “librarian” for the shared folder who will check everything and place it in the correct shared folder.
- Add Metadata to the folders:
This makes them better searchable.
- Add structure to the portal:
There are a number of different ways that a portal could be structure to improve efficiency to business users. For instance:
- Reports could be stored by subject area, such as 'finance', 'sales', 'supply chain'
- Reports could be stored in a 'daily', 'weekly', 'monthly' directory structure depending on how often they have been designed to be refreshed.
- Reports could be stored by perspective:
- Financial — Groups objectives, initiatives, and KPIs that relate to or support the monetary or economic health and development of your organization.
- Customer — Groups objectives, initiatives, and KPIs that pertain to or support your client base.
- Internal Process — Groups objectives, initiatives, and KPIs that categorize and support your corporate internal policies and procedures.
- Learning and Growth — Groups objectives, initiatives, and KPIs that relate to or support employee training and advancement.
- A combination of the above.
Till Next Time
OBIEE11g Golden Rules: Dashboard Building
First of al the original inspiration for these “Golden Rules” Series are based on the “20 GOLDEN RULES FOR REPOSITORY DESIGN” from the people at Peak Indicators. Kudos to them. I just added my own observations.
The series contains:
- RPD-Physical Layer
- RPD-Business Model Layer
- RPD-Presentation Layer
- Report Building
- Dashboard Building
- Catalog management
The “rules” is this article are somewhat in random order
This is really a work in progress, will be updated soon! (Bit pressed for Time 
)
Dashboard Design
- Don’t crowd the dashboard
Divide your report over several pages! Check why a user really needs 25 pages…..
- Avoid scrolling
Remember that your developers screen is often bigger then the user screen
- Check for screen size
If the user has only a 1024 * 768, then make your own resolution the same!
- Check for mobile
- Animation
- Colours
Before you start using non standard colours have a look a some colour theory: http://en.wikipedia.org/wiki/Color, not every colour combination does well…..
This is always a “work in progress” and please feel free to make any suggestions!
Till Next Time!
