Salut tuturor,

as avea si eu o intrebare.
Lucrez cu sql server 2005. Am de realizat un Raport in Reporting Services (un matrix):
An/Luna/Saptamana/Zi an curent - An/Luna/Saptamana/Zi  anul trecut.

Cu ajutorul unui Assambly  - sincronizez: Luni a.c. cu Luni anul trecut (Luni 18.Oct.2010 Vanzari:10 000 - Luni 19.Oct.2009 Vanzari: 9 200)

  A.C.                           A.T.                        Vanzari
Vineri 01.10.2010       Vineri 02.10.2010       5 000 (a.c)
Luni    04.10.2010        Luni   03.10.2010         6 200 (a.c)
...                                    ...                            ...
...                                    ...                            ...
...                                    ...                            ...
Luni  19.10.2010         Luni  18.10.2009          6 900 (a.c)
Marti 20.10.2010        Marti19.10.2009          9 000 (a.c)



Problma este:
trebuie sa compar Luna a.c. (01.30.2010) cu Luna a.t. (01.30.2009)
ParallelPeriod (mdx) nu functioneaza, deoarece am o sincronizare a zilelor de saptamana.
De ceea ce eu as avea nevoie, in matrix:

A.C.                           A.T.                          Vanzari
                                Joi      01.10.2010       6 100 <- aceasta pozitie imi lipseste din raport.
Vineri 01.10.2010       Vineri 02.10.2010         5 000 (a.c)
Luni    04.10.2010       Luni   03.10.2010         6 200 (a.c)
...                                    ...                            ...
...                                    ...                            ...
...                                    ...                            ...
Luni 19.10.2010          Luni 18.10.2009          6 900 (a.c)
Marti 20.10.2010        Marti19.10.2009          9 000 (a.c)

Are cineva vreo Idee cum as putea rezolva aceasta prolema cu ajutorulu unui script MDX?
Sau o alta idee?


Va multumesc anticipat
Ysa

Presupun ca folositi Analysis Services.
Ce cod folositi pentru generarea datelor?
Daca includeti ziua Joi 30.09.2010, nu va apare in raport si Joi 01.10.2009 ?

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro