Viewing 15 posts - 106 through 120 (of 341 total)
There are all sorts of resources available, just depends on your preference (book, classroom, hands-on labs, videos, etc.). Here are a few resources to get started with:
Microsoft Virtual Labs...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 9:09 am
So far the only thing that has been announced is H1 of 2010. Nothing more beyond that has been released so far. Don't forget that the next release...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 8:55 am
Robert Bruckner has some examples of how to go about this:
The Pace is Glacial (Hangman Report)
Multi-Player Gaming in RS (aka BI Power Hour 2008)
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 8:52 am
While Report Builder 2.0 is a great front-end reporting tool for end-users, you might need to explore other tools that will allow end users to create these types of reports...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 8:46 am
Instead of trying to setup filters this would be more optimal to setup in the cube to return your results. This is exactly the types of questions that SSAS...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 8:41 am
Excel 2007 is a good tool if that is all you can use for the time being.
Excel 2007 Document: Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
Here...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 9, 2009 at 5:38 am
How are you doing your ETL? Are you using SSIS? If so, take a look at this thread in the Microsoft forums - ssis package documentation
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 9, 2009 at 5:34 am
You need to set a property on the attribute within the dimension in the SSAS database. The property that you will need to set is 'InstanceSelection' this defaults...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 30, 2009 at 6:12 pm
Yeah, you can use Except or - (minus).
MDX Essentials: Basic Set Functions: The EXCEPT() Function
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 30, 2009 at 5:59 pm
Then you will need to use the convert(varchar(10), , 101) and you would get a result in the format of mm/dd/yyyy.
You will just need to specify the style code for...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 30, 2009 at 4:25 am
In the named query or in a database view you can use the following to return just the date portion:
dateadd(dd,datediff(dd,0,),0)
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 29, 2009 at 1:50 pm
With the missing dimension key it would basically mean that there is no match for the fact record in your dimension table. Are you certain that the dimension tables...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 29, 2009 at 1:46 pm
If you have SSAS 2008 you can utilize Dynamic Sets now.
Take a look at this posting and this might help you in resolving this issue - http://www.setfocus.com/technicalarticles/kgoff/mdxnamedsets.aspx
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 29, 2009 at 1:44 pm
Haven't taken the actual upgrade exam, but I did take both of the beta 2008 tests. Here is the feedback on the MCITP exam for 2008 - Quick Feedback...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 5, 2009 at 5:05 am
If you take a look at the Adventure Works DW sample (2005 version) on CodePlex you should be able to take a look at some examples of Actions.
Here is there...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
June 1, 2009 at 8:24 pm
Viewing 15 posts - 106 through 120 (of 341 total)