Viewing 10 posts - 331 through 341 (of 341 total)
Items like semi-additive measures, perspectives, partitioning, proactive caching, and write back are a few. For more information and details go to the following link and scroll down to the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 4, 2008 at 11:43 pm
Take a look at the BOL material http://msdn.microsoft.com/library/ms145989.aspx and you can take a look at downloading the Analysis Service sample database, Adventure Works, here http://www.codeplex.com/SqlServerSamples. They have some examples...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 3, 2008 at 9:15 am
Don't see anything wrong with your query. I modified it to work against the Adventure Works and it runs without any issues.
WITH SET [OrderedSet] AS
ORDER...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 2, 2008 at 11:02 pm
If you only have one fact table and both dimensions are related to the fact table then I see no reason why you couldn't do this. Sounds like you...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 2, 2008 at 10:43 pm
I would recommend checking out all of the content on the Kimball Group's site and also their book The Microsoft Data Warehouse Toolkit: With SQL Server 2005 and the Microsoft...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 26, 2008 at 6:30 am
You should be able to use the list report item and then drag the chart into the list item. The parameters would be feeding a dataset that would then...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 24, 2008 at 7:51 pm
There is lots of content all over the Internet in regards to SSAS tutorials and overviews. Here are a few for you to checkout - http://www.accelebrate.com/sql_training/ssas_tutorial.htm or you...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 24, 2008 at 7:44 pm
It appears that you are missing some curly braces within your crossjoin:
change this section:
non empty({
[first twelve], [Accounting Date].[Month].[Remaining Months]
--* [Procedures].[Billing Groups].[Billing Groups].ALLMEMBERS
}) on rows
to this:
non...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 3, 2008 at 7:57 am
First of all you won't be limited to the number of processors you can utilize on the server. SSAS Enterprise will provide parallel processing capabilities, partitioning your measure groups,...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 27, 2008 at 12:50 pm
If I am following what you are getting at then you want to display the first twelve months of data broken out by each month and then the remaining months....
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 27, 2008 at 12:36 pm
Viewing 10 posts - 331 through 341 (of 341 total)