Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, April 29, 2013 2:01 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:07 AM
Points: 126, Visits: 236
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