I have inherited a universe that does not employ a true star-schema and it is causing me grief. The very wide fact table (Shipment) has few dimensions (many decodes of were done in ETL and placed into the very wide fact table - again, i inherited this), but most of the joined tables are not true dimensions. They instead have multiple rows for a single fact table row. An example would be a single Shipment (fact) has 2 Commodities (dimension), so the Shipment ID is on the Commodity table. Therefore, any measure from Shipment gets returned as many times as the number of objects from the Commodity when an object from the Commodity table is included in the query. How do I get around this? Can I not have any objects defined as measures if I have a join from the fact table that is actually one fact to many dimensions? If this does not make sense, I can include SQL and/or a report. Or, if this has already been covered, please point me to the discussion. My training books from Business Objects assume a star-schema and I donโt see this in the Cindi Howson book.
Thank you.
stephen (BOB member since 2006-02-17)