Unit Test plan for MSBI RRS feed

  • General discussion

  • Hi,

    Does anyone have a template or sample unit test plans for MSBI?

    Our projet involves creating cubes and exposing these cubes to users for Ad-hoc reporting thorugh Report Builder or Excel. What kind of Unit test cases should be created to properly test these cubes?

    Also, what kinf of Unit Test cases should be written for ETL and Reports?

    Any help is appreciated.


    Wednesday, March 7, 2012 4:29 AM

All replies

  • Hi ,

    The Unit Test Cases will be on the following Lines

    1. ETL

    Is the Loading of each of the Data Files happening Correctly and Notifications sent

    Are the Errors handled and Notifications sent.

    Is error Logging enabled.

    Does the Loaded table refelect the Values enetered.

    is the ETL Job to Process cubes working fine in various scanrios first load,Incremental Load etc..

    This is done for each file Job cube etc.. and can be extended.

    2. Data

    Is the SSAS Cube showing right Data.

    Are Partitions getting Created incase of Dynamic Paratition

    Are attribute Values showing the right value

    Are calculated memebers shoing right Values

    3. Security

    Is Data Level security fine Write a test case for each one For a Region only the regional manger should see data does this work fine for Asia EMEA etc..

    Is Report level security fine

    Does a report show up for a user who is not supposed to see the data.

    4. Reports

    Does the Report show the right Values for the selections made

    does it sow user friendly names etc..

    These are some of the things.

    Hope it helps.

    Thursday, March 15, 2012 12:16 PM