1) To provide the Logical level for the Dimension hierarchies in the fact table. For the aggregate tables added logical level is the least level before detail (or depending on the requirement) and for others it is detail.
2) To filter the values of the table. The data getting populated from the table is restricted using 'Where' clause. This can be done in RPD in online mode also. Goto table source> content> use this where clause> expression builder (...)> required condition.
3) Fragmentation Content
This is mainly used for increasing the performance usually done if the records are more than 100,000 in table. By creating partitions for required table at the database level, There sources pointing to the same table are created for the required table in BMM layer. BI server will be chosing from the three sources of the table based on the query required.
Example: If there are 9 Million records in a table, the table is partitioned for 3Million records each. Then we create 3 sources for the table all pointing to the same table.
Then in ‘content’, in ‘Fragmentation Content’, give condition for each table source created.
Example: Customer_id between 1 and 3Million
Customer_id between 4 and 6Million
Customer_id between 7 and 9Million
No comments:
Post a Comment