SELECT StrToSet ('{[Geography].[Geography].[Country].[Germany],[Geography].[Geography].[Country].[Canada]}', CONSTRAINED)
ON 0
FROM [Adventure Works]
http://msdn.microsoft.com/en-us/library/ms144782.aspx
STRTOSET WITH LIST OF QUALIFIED MEMBER NAMES
SELECT StrToSet ('{[Geography].[Geography].[Country].[Germany],[Geography].[Geography].[Country].[Canada]}', CONSTRAINED) ON 0 FROM [Adventure Works] http://msdn.microsoft.com/en-us/library/ms144782.aspx
0 Comments
You can use the script below to clear analysis DB cache, you can run this xmla script into the cube.
<Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <ClearCache> <Object> <DatabaseID>dwSampleCubeDB</DatabaseID> </Object> </ClearCache> </Batch> |
Welcome!Welcome to our edition of eblog! This section will help you find various post and articles that can help you in some of your IT work especially implementing MS BI Solutions. We hope you find this section useful. If you will need further information, please send us your questions and inquiries by going to the "Contact Us" section. Enjoy reading. [Jhon S] Categories
All
|