Viewing 15 posts - 286 through 300 (of 341 total)
Yeah, like I stated before if you haven't searched his site, Jamie knows SSIS inside out.
Here are a couple of links that might help you out in setting up your...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 8, 2008 at 2:26 pm
Will you know or be able to generate the name of the file name? You can setup the file connection managers connection dynamically using expressions. You can also...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 5, 2008 at 9:02 am
So in the SSAS database in the date dimension is there a relationship between month name and month? Which is related to which? You could just set the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 3, 2008 at 5:21 am
In regards to the keys in being alphanumeric in the source table, those would be referred to as natural keys. For best practices you want to typically stay away...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 3, 2008 at 5:04 am
Seems rather unlikely that you would have 400+ metrics. I would think that some of these are possibly attributes of a store (like size, etc.) and not metrics, but...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 2, 2008 at 10:33 am
It appears that you need to take a look at the dimension design in the SSAS database. Are the key and name column properties for this attribute set to...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 2, 2008 at 10:17 am
With SSRS 2000 and 2005 there is Report Builder 1.0 and with SSRS 2008 there is still Report Builder 1.0 in the Report Manager for the time being. They...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 2, 2008 at 8:54 am
It is included in every edition except Express (unless you are using the Advanced release).
Compare the Editions and features included - http://msdn.microsoft.com/en-us/library/cc645993.aspx
SSRS 2008 does not have a dependency...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 1, 2008 at 10:06 am
Typically you would do this in your ETL process. Not sure how you have this setup currently (stored procedures, SSIS, etc.). Not sure what your requirements are to...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
December 1, 2008 at 9:22 am
For more information about this you can refer to my previous posting in the TechNet forums here - PerformancePoint and SQL Server 2008
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 28, 2008 at 10:24 am
I would make sure that you have processed the dimension first and then try processing the cube. Typically data will get refreshed in the fact table and you will...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 28, 2008 at 8:56 am
This isn't the only way to get at the result, but here is an example against the Adventure Works. Basically creating a set of the products excluding the item...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 28, 2008 at 8:10 am
I have been working with Oracle 11g and SSIS on x64. The main issues I have seen are to make sure you have the 64bit Oracle Client installed on...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 28, 2008 at 7:39 am
I have done this for PPS 2007 M & A and after you download and install SP1 you will be fine and you will be able to proceed with the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 28, 2008 at 7:32 am
nice job. was thinking that maybe you had to register asp.net with iis, but maybe that wasn't the issue or maybe it was resolved after you installed the framework.
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 21, 2008 at 8:24 pm
Viewing 15 posts - 286 through 300 (of 341 total)