Cognos conformed dimension. . Dimensions are conformed when the data values that come from the original data sources use the same business keys, or source data, that is used in other packages or models in your IBM® Cognos® environment. For example, in two data stores for Revenue and Inventory that contain Products and Time dimensions, it is possible to define the Products and Time dimensions Dimensions are conformed when the data values that come from the original data sources use the same business keys, or source data, that is used in other packages or models in your IBM® Cognos® environment. For example, in two data stores for Revenue and Inventory that contain Products and Time dimensions, it is possible to define the Products and Time dimensions User actions COGNOiSe. A conformed dimension is simply a dimension which is exactly the same across the business. Jul 5, 2016 ยท Hi, I'd love to know the best practices of modelling the scenario below. Conformed dimensions allow your users to combine or cross data sources successfully when their business needs require that they do so. A query on multiple facts and conformed dimensions respects the cardinality between each fact table and its dimensions and writes SQL to return all the rows from each fact table. While modelling the Data Warehouse, I came across the scenario where we have many fact tables joined by many conformed (also acting as role playing) dimensions. Basically, each star schema (single fact table and it's dimensions) will be identified and treated as a separate query, then all the separate star schema queries will be stitched together. 8ve dcsln2 mf2ub 5lfsyjy ln4r 9lvakt qopcimyd egca egofjx mok4v