by Ricardo Badill » Sun, 17 Mar 2002 02:26:31
How do I make a MDX that shows me the following results in relative times?
Sample:
Today
Yesterday
Last Month
Last Quarter
Last Year
Same Month Last Year
etc etc etc
Im using ParallelPeriod function with the following sintax
PallelPeriod([?Level?[, ?Numeric Expression?[, ?Member?]]])
How do I get the last date on a Time dimension? o replace it in the
<<Member>> parameter??
Thanks!!!
Ricardo Badillo
by Jér?me Poudo » Sun, 17 Mar 2002 03:12:37
strtomember("[Time].[" + format(Now()) , "YYYY\.\[M\]\.\[D\]"))
result of the formula :
[Time].[2002].[3].[15]
> How do I make a MDX that shows me the following results in relative times?
> Sample:
> Today
> Yesterday
> Last Month
> Last Quarter
> Last Year
> Same Month Last Year
> etc etc etc
> Im using ParallelPeriod function with the following sintax
> PallelPeriod([?Level?[, ?Numeric Expression?[, ?Member?]]])
> How do I get the last date on a Time dimension? o replace it in the
> <<Member>> parameter??
> Thanks!!!
> Ricardo Badillo
by Ricardo Badill » Wed, 20 Mar 2002 00:43:46
--
Saludos,
Ricardo Badillo
STAFF Consultant
Grupo MAS - Costa Rica
(506) 233-7133
> strtomember("[Time].[" + format(Now()) , "YYYY\.\[M\]\.\[D\]"))
> result of the formula :
> [Time].[2002].[3].[15]
> > Hello there,
> > How do I make a MDX that shows me the following results in relative
times?
> > Sample:
> > Today
> > Yesterday
> > Last Month
> > Last Quarter
> > Last Year
> > Same Month Last Year
> > etc etc etc
> > Im using ParallelPeriod function with the following sintax
> > PallelPeriod([?Level?[, ?Numeric Expression?[, ?Member?]]])
> > How do I get the last date on a Time dimension? o replace it in the
> > <<Member>> parameter??
> > Thanks!!!
> > Ricardo Badillo
1. how to program for period-to-period comparisons ?
Hi
What's the best way to generate period-to-period comparisons (e.g. for
variance analysis) where you want to generate 2 columns (with different
names, but otherwise similar data-type & values). For example,
SalesCurrent SalesPreviousYear Difference
------------- ------------------- -----------
The difference column, I can handle in the report writer; that part's easy
enough.
I was going to generate the "current" and "previous" columns from
parameterized stored procedures, since, assuming large data volumes, I don't
want to simply limit a huge, generic View on the (e.g. VB) client front-end.
In Access (with small data volume) I could join two queries in a third
query; but, Transact_SQL doesn't want parameters in Views (bummer <G> ) ...
and I want to limit the initial recordsets, rather than use a parameterized
stored procedure (step 2) on huge, generic Views (step 1).
Although I have access to SQL Server 2000 (as an MSDN Developer), the data
resides on SQL Server 7 (precluding UDFs ? ).
I'm about to attempt this with "table variables" (i.e. declare variables of
data-type "Table"), but can't find examples in my books ("Guru's Guide to
Transact-SQL"/Ken Henderson, "Programming VB6"/Francesco Balena or the
"Hitchhiker's Guide to VB & SQL Server"/Bill Vaughn). So, it occurred to me
that I might be approaching it all wrong?
The (spreadsheet) need to generate period-to-period variance comparisons is
so common that I was surprised to find NO Transact-SQL examples on it !!!
thanks, in advance, for whatever insights ...
Michael Coughlin
2. async stored procedure from VB / can you do it?
4. JOB - 4GL P/A - Scottsdale/AZ
7. Relative Time Custom Members
9. records occurring in relative time window
10. Time Relative Categories in OLAP 7
11. Relative times
12. Facts that only exist in PERIODS of time
13. Time periods in a star schema?