http://msdn.microsoft.com/en-us/library/gg492190.aspx
Srinivasan Turuvekere on the product team says "These two functions are not the same. This function will return true if there is exactly one dire…
Created on 6/4/2013 (updated 1 day ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 789519
|
|
|
Resolved
as Fixed
|
|
On the Adventure Works Tabular model, expand the Reseller Sales table to 100 million rows then run the following MDX query:
select {[Measures].[Reseller Order Lines Count], [Measures].[Reseller Total…
Created on 5/15/2013 (updated 4 weeks ago) | 2 validations | 0 workarounds | 1 comment | feedback id: 787006
|
|
Run this against the Adventure Works Tabular model twice from a Management Studio MDX window.
EVALUATE
ROW(
"OrdersOver5Units", SUMX('Reseller Sales', IF('Reseller Sales'[Reseller Total Units]>10,1…
Created on 5/12/2013 (updated 5 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 786802
|
|
http://msdn.microsoft.com/en-us/library/ms174514.aspx
"Values over 100 represent memory limits in kilobytes." That is incorrect as mentioned by several comments at the bottom. It should say "bytes". …
Created on 5/4/2013 (updated 5 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 786362
|
|
Start a perfmon trace and choose the following counters on a server with AS2012 SP1 CU1:
* MSAS11:Memory\VertiPaq Paged KB
* MSAS11:Memory\VertiPaq Memory-Mapped KB
* MSAS11:Memory\VertiPaq Nonpaged…
Created on 5/1/2013 (updated 6 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 786054
|
|
I have an SSRS report which runs an MDX query. The MDX query has 5 parameters and returns one dimension on rows and 34 measures on columns. It's large, but fairly typical in size to many other repor…
Created on 3/27/2013 (updated 11 weeks ago) | 0 validations | 0 workarounds | 1 comment | feedback id: 782270
|
|
Go to http://asstoredprocedures.codeplex.com/releases and download the ASSP 2012 assembly (the zip file, not the XMLA file). Unzip that file, unblock the DLL as described here:
http://asstoredprocedur…
Created on 2/21/2013 (updated 11 weeks ago) | 1 validation | 1 workaround | 0 comments | feedback id: 779739
|
|
Unzip the attached zip file which contains a .abf which is an Analysis Services backup. Restore this to an Analysis Services 2012 SP1 instance. Then connect to this database in Excel. Make sure to pic…
Created on 2/14/2013 (updated 1 week ago) | 2 validations | 0 workarounds | 2 comments | feedback id: 779232
|
|
Look at the attached cube. Unzip and restore it to SSAS2012 SP1 CU1 or higher. Note it's got one measure group with 3 dimensions in the Adventure Works cube. But note that there are 40 other dimension…
Created on 1/26/2013 (updated 20 weeks ago) | 0 validations | 0 workarounds | 0 comments | feedback id: 777597
|
|
Here are some simple steps to reproduce the "ReadElementContentAs() methods cannot be called on an element that has child elements" error that occurs when opening a .bim file in a Tabular model after …
Created on 1/13/2013 (updated 8 weeks ago) | 5 validations | 0 workarounds | 2 comments | feedback id: 776444
|
|
|
Closed
as Fixed
|
|