title: Cognos FM snowflake or star schema? Help with hierarchies needed
body: <p>I need some help with modeling in Cognos Framework Manager 8.4.
  Given following schema </p>
  
  <p><img src="https://i.stack.imgur.com/Ldk92.jpg" alt="alt text"></p>
  
  <p>where </p>
  
  <ul>
  <li>F_sales.order_key references
  D_order.sid</li>
  <li>D_orderItems.orderID references
  D_order.OrderID</li>
  <li>D_productAttributes.OrderItemID
  references D_orderItems.orderItemsID</li>
  </ul>
  
  <p>When creating reports via Cognos Report Studio I am not able to filter for orders which have orderItems which have attributeKey e.g. 'shippingType' and attributeValue 'Standard' or 'Express' or whatever. </p>
  
  <p>I guess the problem is the quasi m:n relationship. In practice this shouldn't be a problem. So I thought a solution would be to create a regular dimension in framework manager with a hierarchy like
  "An order can consist of multiple order items and each order item has multiple attributeKeys and -values"</p>
  
  <p>Is this the solution and how would I do that? Can someone guide me, please?</p>
  
  <p>Or is it okay like it is and I am missing something in Report Studio? In my test I just created a list which has the facts from fact table and orderID from D_order. Filtering for everything else works fine, but there is no effect when filtering for e.g. D_productAttributes.attributeValue = 'Express'</p>
  
  <p>Thanks in advance.</p>