Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

WHow to add time or date dimension in a cube Expand / Collapse
Posted Monday, April 29, 2013 2:01 PM


Group: General Forum Members
Last Login: Monday, March 21, 2016 11:37 AM
Points: 187, Visits: 394
I am working with Northwind database and created ordercube.which has orders table as a facttable and customers,order details suppliers table as dimensiontables.
I could build cube on orders table successfully but while building a message pop up to create time dimension which was not created automatically.Now my
Orders table has date related coulmns in it how do I get that as time/date dimension in my cube?
Please tell me how to add any new dimension later on after creating cube?and see that in browser I can not see my newly added dimension in cube designer???how to do this?
Post #1447752
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse