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!

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

need to create fact at week level

Status
Not open for further replies.
sekar211

sekar211

MIS
Dec 15, 2003
55
US
Hi:
i need help in creating fact.i have a dimension table with date_dm and week_dm. thers is one fact with date_id from dimension table.when i want to create a fact at week i need the week should have 8 days for 1 week not regular 7 days per week which i have currently .can anyone explain how to add 1 day to the current week when calculating for week
 
Status
Not open for further replies.

Similar threads

RosaNegra
  • Locked
  • Question
Microstrategy Apply Simple Week calculation
Replies
0
Views
103
RosaNegra
RosaNegra
newbie2009
  • Locked
  • Question
How to access data from a REST Url with Microstrategy Xquery
Replies
0
Views
91
newbie2009
newbie2009
szeiss
  • Locked
  • Question
Passing Prompt Answer to Metric
Replies
0
Views
115
szeiss
szeiss
MSTRPRG
  • Locked
  • Question
fact with start and end date
Replies
0
Views
54
MSTRPRG
MSTRPRG
dinzana
  • Locked
  • Question
Comparing sysdate()-1 to another date in multiple datasets in a report document.
Replies
0
Views
98
dinzana
dinzana

Part and Inventory Search

Sponsor

Back
Top