
Hi,
Using SSAS we are trying to analyse Data for sales orders based on current and previous dates.
In cubes we are using calculated members for that, now the problem is that we are unable to pick/get the current/previous date info for comparison/analyse the data/records.
Please advise us on how to get the date info which includes complete date info/year/month from the system date current basis.
Regards,
Suba.
*This post is locked for comments
I have the same question (0)I saw an example of a query using yesterday's date in this blog posting.
social.msdn.microsoft.com/.../2e93514e-38ac-43cc-8287-dd24c461c28c
Does that help?