When using hierarchical dimension in the report when you click to drill down hyperlink will display items - columns that are set for a given level. If there is one level more items, we want to see in the report, not simply affect the display order of items. The original order of columns in the report by clicking on the hyperlink to drill down: To the desired order of display items is necessary when you create logical layer (dimensional table) to transfer these items from the Physical layer in exactly the reverse order than the order as we want in the report . It is influenced by assigning ID these items in the repository . According to these IDs are then carried out an internal evaluation of the display sequence . The required order of the columns in the report after click to drill down hyperlink: ID in the repository for items mentioned in the original order: ID in the repository for items mentioned in the desired order:
Posts
