Home | Ciber
Knowledge page of Ciber Netherlands

OBIEE Naming Conventions – Presentation Layer

clip_image002

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

Read more

No reactions

OBIEE Naming Conventions – Business Model Layer

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

clip_image002

Read more

No reactions

OBIEE Naming Conventions – Physical Layer

clip_image002

This Article is only a guideline to an OBIEE naming convention for the repository. The most important aspect of a naming convention is that you use it consistently. The used naming convention should be readable for any future development.

Read more

No reactions

OBIEE using display folders

Most repositories have a natural tendency to grow in the time they are “alive”. For the Physical and Business layer OBIEE has the option of using display folders:

image

Which is a nice way to organise your stuff and most of all to have it look more “professional”

image

These folder only contain shortcuts to the “base” material.

image

So let’s start organizing our stuff ;-)

Till Next Time

No reactions

OBIEE Start reading on graphs!

OBIEE 11g is coming!

We don’t no when, but we do know that the increase in graphical possibility’s will be HUGE!.

In that lays a huge danger, developers have a natural tendency to try out all options, and even worse give all the options to their clients often resulting in very “colourful” dashboards.

If you are coming from OBIEE 10G and want to prep for 11g you might want to catch up on some reading on how to make good graphs, instead of only colourful graphs!

For several years the books of Stephen Few: (http://www.perceptualedge.com/blog/) where considered as the one and only standard. Certainly he was one of the first to write things down: (Information Dashboard Design: The Effective Visual Communication of Data ) This is still a must read for every Dashboard developer.

Recently a new book has arrived “The wall street journal guide to information graphics” by Dona M. Wong. Personally I find this easier to read then the Stephen Few book. I like the setup where on the left page there is a “bad” example and on the right side there is a “good” example. Another good feature of the book is the statistical “brush-up” chapter.

Till Next Time

No reactions

OBIEE ATR files (reports).

The ATR files in the OBIEE repository manage privileges on a item and provide a “readable” text for both the name and description of an object. Dan Malone of Calpoly did some basic research on how these work.

This article describe the build up of the ATR file when used for a report.

WOW: backup the files before you start to hack them, one misplaced byte can really f*&^k up your system!

Read more

No reactions

OBIEE Reset OC4J Admin password

Didn’t I read about this in several other blogs you might ask. Well you are right there. It probably started with the guys from carpe diem: http://carpediemconsulting.wordpress.com/2008/03/16/resetting-the-oc4j-password-in-obiee/ And since all the others copied there article from them nobody noticed they didn’t clear the security cache. Here is the version from the original documentation:

  • Stop OC4J and the Application Server Control.

  • Read more

    No reactions

    Import vanuit Excel heeft haken en ogen

    Ciber SSIS specialist Frank Reterink heeft eens uitgebreid onderzocht wat nu de haken en ogen zijn bij de import vanuit Excel via SSIS.

    Inleiding (uit de “literatuur”):

    Bij de import van Excel bestanden maakt de Excel connection manager in Integration Services gebruik van de “Microsoft OLE DB Provider for Jet 4.0” en de ondersteunende “Excel ISAM” driver Deze driver heeft een aantal eigenaardigheden:

    - Data bronnen:
    Voor het aanroepen van en sheet of benoemd data bereik moet achter de naam een $ geplaatst worden. Om syntax errors te voorkomen moet die complete naar door rechte haken [Sheet$] omgeven worden.

    Read more

    No reactions

    OBIEE Google Charts part 3 QR Codes

    Ever seen these:

    image

    They are QR Codes: http://en.wikipedia.org/wiki/QR_Code. Most modern mobiles have a small application on board which can read the information. Because of the build in error correction they are ideal for stuff like address labels.

    Read more

    No reactions

    OBIEE Google Charts part 2

    Impress with real venn diagrams:

    image

    First get your data:

    Read more

    No reactions

    « Previous pageNext page »