Wednesday 17 April 2013

Display Measures in Multiple Display Folders

One day, my client suggests me to create different measure group for a set of 25 measures in the cube. The main purpose was to create set of measure for different -2 users, so that they can easily search and view required measures out of hundreds. In that case, it was obvious that one measure will fall in multiple folders. Also, if folder will arrange in hierarchical view then it will more easy to find them.

This can accomplish by using display folder property of measure. Write multiple folder name separated by semicolon. If folder is hierarchical then write complete path separated by backslash. 

After reprocessing this is what the results look like below. Measure will display in those folders during browsing of the cube. This image shows a measure that lands under multiple displays folders, but this can be done with dimension attributes as well.`


Finally, it fullfill my requirement. yours?

1 comment:

  1. I simply want to say I’m very new to blogs and actually loved you’re blog site. Almost certainly I’m going to bookmark your blog post . You absolutely come with great well written articles. Thanks a lot for sharing your blog.

    MSBI Training in Chennai

    ReplyDelete

Azure AzCopy Command in Action

Azure AzCopy Command  in Action -  Install - Module - Name Az - Scope CurrentUser - Repository PSGallery - Force # This simple PowerShell ...