Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Product Launch Dates

Status
Not open for further replies.

datawrangler

Technical User
Sep 14, 2004
37
US
I need to add the Launch Date of each product in my sales analysis mdl. I can create a master table with products and the minofinvdate where sales are >0 and insert it as a new data source. but if i do this, not all products in the first(main) datesource will be in my second data source (because in my first data source, i have products that never sold and promotional products as well). this is causing my other "products" dimenstion levels to be unbalanced and the cube will not build. any suggestions on the best way to analyze the sales of products from their original launch date (date of first actual sale). any help is greatly appreciated. the simpler the better...

Fyi, I already have a monster time dimension for straight sales.



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top