Viewing 15 posts - 91 through 105 (of 341 total)
You can reference the member properties by doing a CurrentMember.Properties(" [Property Name] ") = " [Your Value] " reference, but why not simply reference the key values instead of the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 10, 2009 at 11:32 am
If you want some hand-on lab experience check out Microsoft's Virtual Labs area - http://www.microsoft.com/events/vlabs/default.mspx
Also take a look at William Pearson, III who has a ton of excellent tutorials on...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 3, 2009 at 5:23 am
The undocumented stored procedure is sp_MSforeachtable, not sp_foreachtable.
So you could do something like the following to return the results quickly:
sp_MSforeachtable 'sp_spaceused ''?'''
There is also the undocumented stored procedure...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
September 2, 2009 at 7:42 am
What OS are you running? If you are running Vista or Win 7 you might want to run SSMS as administrator or go into the Compatibility tab of the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
August 28, 2009 at 6:50 am
Besides what is stated here for deployment you will need to see if you are part of the SSAS Server Administrators. When you installed SSAS 2005 there was an...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
August 28, 2009 at 5:31 am
You can download and setup the sample reports that will allow you to create a reporting repository based off the execution log. This is part of the sample reports...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
August 26, 2009 at 2:29 pm
You need to go into the data source view and define the relationship between the two columns within the table. Once you do this the wizard will pickup on...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
August 4, 2009 at 11:23 am
Take a look at these postings:
Loading and Running a Local Package Programmatically
http://msdn.microsoft.com/en-us/library/ms136090.aspx
Running SSIS package programmatically
http://blogs.msdn.com/michen/archive/2007/03/22/running-ssis-package-programmatically.aspx
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 31, 2009 at 9:10 pm
For information about SSAS check out this site - http://ssas-info.com
There is a good list of books listed here - http://ssas-info.com/analysis-services-books
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 25, 2009 at 8:09 am
If you are using the RDLC and the Microsoft Report Viewer control then you should check out this site - http://gotreportviewer.com. This site has lots of useful information, FAQs,...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 25, 2009 at 8:03 am
Can you possibly provide an example of what you are looking to get at for the results?
I am thinking, but not certain, that you will want to put the sort...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 17, 2009 at 12:02 pm
My bad, thought you were just trying to add some additional calculations from your fact table that you might have added or did not include originally.
Yeah, this can be done...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 13, 2009 at 11:31 am
Use the option in the cube structure tab of the desired cube to add 'New Measure'. This is available in the toolbar or by right-clicking in the Measures...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 13, 2009 at 10:58 am
With Excel 2007 and RB 2.0 going directly against the cube that would allow for a little more flexibilty with the end-users since they could define their own calculations and...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 12, 2009 at 6:57 am
That is why requirements gathering is extremely critical in the creation of any solution. Without the proper requirements how can you just try and build a solution unless you...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
July 11, 2009 at 3:23 pm
Viewing 15 posts - 91 through 105 (of 341 total)