Profile picture for user Peter Björklund

We use SAP Business Objects. I wonder what model types and object types that are useful for modelling our Business Intelligence Architecture? Are there such objects in the default ARIS Method or do we have to purchase the BI modeller?

Kind regards

/Peter

by Pierre Pilven
Posted on Tue, 11/29/2011 - 01:07

Hey Peter,

I've used, MER diagrams and Table Diagrams to do so.

I've used objects : Tables ; fields ; Classes ; MER Attributs, and added some new symbols to distinguish datawarehouse tables and fields from others.

With a custom script, I've imported and draw automatically datawarehouse structure in ARIS (every table and fields), i've done the same with ERP structure.

Then I've used Access Diagram to modelize transformations done on ERP datas before loading them into DWH.

Afterwards IT people design BI Report specifications in ARIS, we are able to generate  a document with relevant information like :

  1. Which informations are needed buy the buisness on there daily reports (Finance, Stocks, Production,...)
  2. Which datas from the DWH are used to build those strategic reports
  3. From which application those datas came from, which transformation have been done to the datas

Those specifications are validated buy the business from the functionnal point of view and buy IT for the technical point of view.

Then we did a second ARIS report to generate BI Report Catalog order buy users :

  1. Finance reports
  2. Production reports
  3. Supply Chain reports
  4. ...

We have sent the catalog to key users, they can choose reports they need for they daily work.

This work have been done to support a project of BI tool migration .

Pierre

 

0
by Peter Björklund Author
Posted on Mon, 12/05/2011 - 16:53

Pierre,

Thanks for your help. I´ve also found the Access diagram and Table Diagrams and they could be useful for modeling the level of the source system and data source. Im afraid that those model types doesnt support two of my primary needs:

- objects showing the staging area level with data stores wich recieves information from the data source 

- objects showing the data warehouse level where the Info cubes uses information from data stores and through queries creates reports.

I have found one model type, called DW structure, that contains some objects that can be used for modeling some parts of the data warehouse level but its not possible to create assignments from those objects to either Table och Access diagrams.

/Peter

 

0

Featured achievement

Rookie
Say hello to the ARIS Community! Personalize your community experience by following forums or tags, liking a post or uploading a profile picture.
Recent Unlocks
  • SS
  • MZ
  • Profile picture for user kbiront
  • Profile picture for user Tony Iliev
  • Profile picture for user amandeep.7.singh
  • PacMan

Leaderboard

|
icon-arrow-down icon-arrow-cerulean-left icon-arrow-cerulean-right icon-arrow-down icon-arrow-left icon-arrow-right icon-arrow icon-back icon-close icon-comments icon-correct-answer icon-tick icon-download icon-facebook icon-flag icon-google-plus icon-hamburger icon-in icon-info icon-instagram icon-login-true icon-login icon-mail-notification icon-mail icon-mortarboard icon-newsletter icon-notification icon-pinterest icon-plus icon-rss icon-search icon-share icon-shield icon-snapchat icon-star icon-tutorials icon-twitter icon-universities icon-videos icon-views icon-whatsapp icon-xing icon-youtube icon-jobs icon-heart icon-heart2 aris-express bpm-glossary help-intro help-design Process_Mining_Icon help-publishing help-administration help-dashboarding help-archive help-risk icon-knowledge icon-question icon-events icon-message icon-more icon-pencil forum-icon icon-lock