In SQL Server documentation it is mentioned that the SP3 Code sample contains the Analysis Service Connection Pooling sample. Please help me in locating the code sample. Thanks in advance.
I have 2 physical DB with same tables access by different applications on the internet. Any idea or suggestion in fullfilling a requirement of data integrity and record locking mechanism?
I have created the following calculated member on my cube Ancestor([Time].CurrentMember, [Time].[Month]), i want to link this to the measures so that i can give me previous month versus the current months sales figures, at the moment when i process the cube this member returns