Migration metadata from Microstrategy to BO

general discussion
1

Hi,

Guys, i have involve to migrate microstrategy reports to Business objects reports.

can you guide where i have to get the documents regarding the above.

Thanks
Svsenni

svsenni (BOB member since 2005-04-28)

2

Not sure what you’re asking for. I nkow of no documents (nor processes) that will help with this.

I think you’ll be building from scratch.

Steve Krandel :us: (BOB member since 2002-06-25)

3

I am working with a client who has been struggling with a rocky migration from Microstrategy to BO. I have not been working directly on the project but, rather, some new BO development, I’ll give you my two cents based on my conversations with those involved in the migration.

You can slap BO universes right on top of what you were using for Microstrategy but you should evaluate your warehouse data model very carefully because Microstrategy allows some query techniques that are not supported in BO, like multi pass queries.

The client I am working at declared the data structure to be “Off Limits” and now they are struggling to get their universes to function the way they want.

I wish I had more information for you but I hope this helps.

Chris

chris_c :us: (BOB member since 2006-01-10)

4

First, a big appology for the long message.

This is certainly not an easy issue. I am in the process of building a migration and implementation plan of moving a Microstrategy environment onto BOBJ and we have many items to consider. Any feedback is welcome.

As chris_c discovered, “slapping” a universe onto the MSTR data structure is not smart because you will need to optimize it first. We also did that and needed to add materialized views / indexes to the database and we are still not finished. Performance is still below our service level agreement.

One item I need to create is a list of items that the MSTR server accomplishes that can’t be done in a Universe(s). Ideally, I want to push the functionality down to the database and not up to the report.

Topics include (but not limited to this list):

  1. Data Manipulation and Aggregation: Multi-pass SQL is one item on the list and I will have a larger list once I meet with the MSTR experts on site but if anyone has other items to add, please let me know.
  2. Dimensionalization and Measures: what features are available within the MSTR server to help build dimensions/measures that can’t be done in a Universe.
  3. Data Security: Mapping the proper data security (ie row level data, report objects, and reports) to the proper users/groups
  4. Functional Security: Identifying what functional gaps exist (ie. view SQL, edit SQL, create reports,…) between the two technologies and how to get around it.
  5. Report Migration: What functionality exists in MSTR that needs some sort of work around in BOBJ.

Does anyone have more to add at this point?

Thanks.

robert_carriere (BOB member since 2003-03-19)

5

Just some general remarks:

  1. As you mentioned Multi-pass SQL will be your main problem in migration process. Due to this ability it’s possible to implement complex calculation on MSTR level while in BO it’s simply beyond reality in most cases. So a great part of calculations has to be done with ETL. You may leave for BO just some simple secondary sum, avg, deviation etc.
  2. For example, BO users’ headache is sorting by the field that isn’t shown in report. MSTR ‘Attribute’= BO ‘Dimension’ may has both id and desc form and you’re able to sort by any of them at the same time not showing them in block.
  3. I think there will be no much problems with security migration cause BO has more extended capabilities in this area.
  4. MSTR doesn’t even have ‘edit SQL’ so don’t worry :slight_smile:
  5. Consolidations and Custom Groups are powerful features for grouping, filtering and classification of data that have no analog in BO. Depending on the complexity of these objects you can substitute some of them with manual scripts. Also there’re represented transformations, drill templates etc.

If you need more detailed information I’ll try to help you.

AlexKey (BOB member since 2006-08-18)

6

I am going to involve MSTR to BOBJ migration, not sure how to start the same. I am looking the migration plan for MSTR to BOBJ, if any one can share the one which prepared

sibjohn22 (BOB member since 2010-08-20)

7

Please not that you have tied to get a response from a a thread that has been dormant for almost 4 years.

Thers is no migration. You will be rebuilding everything.

Steve Krandel :us: (BOB member since 2002-06-25)

8

Thanks for your replay.
That means we have to take the details of existing MSTR reports and rebuild the same in BO

sibjohn22 (BOB member since 2010-08-20)