You are currently browsing the monthly archive for May 2010.
A lot of times the MDX query needs to look at current date/today date/system date as the reference member. There is no function equivalent to TSQL getdate(), but you can use the following piece of cide snippet to solve the purpose:
StrToMember(“[Date].[Date].[" + Format(now(), "yyyyMMdd") + "]“)
As an example, if you want to see the Sales for the last 7 days from the system date:
SELECT
[Measures].[Sales] ON COLUMNS,
LastPeriods(7, StrToMember(“[Date].[Date].[" + Format(now(), "dd-MM-yyyy") + "]“) ) ON ROWS
FROM [Cube]
Installed MOSS 2007 SP2 on a 64-bit machine running Windows Server 2008, and restored a site collection from another domain. Running into SSRS issues (but lets save that for later !). Tried to open the site url in Windows Explorer and ran into errors. Then tried openning a sharepoint list using Actions -> Open with Windows Explorer, and the same problem. Got this error message”
Your client does not support opening this list with Windows Explorer.
Turns out, this is because the Desktop Experience feature was not installed. Installed as follows:
1.Click Administrative Tools -> Server Manager
2.Expand the Features node
3.Click Add Features
4.Check Desktop Experience, and install
5.Restart the server once done.
