May 27, 2014

How to group free characteristics in Portal or Web Analyzer


Introduction

                      We use several free characteristics in our reports for drill down purpose. At times, we are forced to use huge no. of drill down chars. It will be cumbersome to view all of them together in a single screen. There are chances for our users to get confused by looking all of them like below.

    Grp1.JPG
                  To deal this issue in a better way, I am going to demonstrate on How to group these free chars as per the entity type
in WAD by using Navigational Block Web Item.

1.     Open WAD and add different "Navigational Block" items to your web template
         
2.    If you want to group as per the Header Customer entity type, then click on the Navigational Block Web item from above and specify the Entity name in the Title like below

  Grp5.JPG

3.     You can select the required Chars and Nav Attrs in the  in Web Item properties like below.

Grp3.JPG

4.     You can create separate groups with different web items in the above fashion and your users can select the required drill down char f rom the Nav Block web item in the Portal like below

  Grp4.JPG

Note : You can correlate with Dimensions in your cube. But with above steps, you can also add Nav Attrs to the group along with dimension chars. You can create total new groups also without concerning the dimension design in the Cube.

No comments: