Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Datepart function
0 views
Skip to first unread message
AlejoR
Apr 29, 2003, 11:58:42 AM4/29/03
to
Hello everybody.
Who knows how to use the DatePart function inside of a Cube... I mean in a
Calculated Member.
I need that if I select a date (from time dimension), datepart returns the
number of the day.
Who knows how to use the DatePart function inside of a Cube... I mean in a
Calculated Member.
I need that if I select a date (from time dimension), datepart returns the
number of the day.
Something like that in SQL:
select DatePart ("weekday",getdate())
Thanks
Ray H.
May 12, 2003, 7:29:38 PM5/12/03
to
You could actually define this in SQL when you create
your star or snowflake schema, you could use it as a
member level for your date dimension or as a seperate
dimension. Having it be part of your ETL would be easiest.
your star or snowflake schema, you could use it as a
member level for your date dimension or as a seperate
dimension. Having it be part of your ETL would be easiest.
Let me know if this is of help
>.
>
0 new messages