Viewing 15 posts - 316 through 330 (of 341 total)
No problem. If you were doing this within in existing package you could load the reader and populate a variable with the results (object type variable). Then in...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 4, 2008 at 3:30 pm
Now that I read your posting again you want to pass the result back to the parent...outputting the result to flat file, raw, or xml would be your best option...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
November 1, 2008 at 6:47 am
I am going to dig around a little further, but I am thinking you might just want to dump this to a flat file or raw file. I believe...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 6:15 pm
Great news. Having SQL Server (DB Engine) and Analysis Services installed and running on the same server would not be recommended in a production environment, but in development you...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 8:25 am
Unless these dimensions are directly related to each other and have a relationship established in the dimension usage of the cube, you would need to filter the dimension based off...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 7:26 am
Really depends on what you are looking at optimizing. Are you having issues with query performance, processing performance, calculated measure optimizations, etc.? Always take a look at the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 7:06 am
You are going to need to create a couple of additional calculated measures to get the particular slices of data you are looking for.
WITH MEMBER Measures.[Quantity sold - Carpenters] as...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 31, 2008 at 6:38 am
Are you running Analysis Services locally on your workstation (do you have it installed)? You need to go into the properties of the project and setup the proper deployment...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 30, 2008 at 7:38 pm
Have you created sparklines in SSRS yet? This can be done with a simple line chart and removing all of the grid lines, legends, etc. and then you can...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 29, 2008 at 2:38 pm
Which version of Analysis Services are you using (2000 or 2005)? Performing an update process on a dimension should not take that long and if you are partitioning the...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 28, 2008 at 7:26 am
Create two data sources and a data set from each to complete the report or look at using the LookupCube function to retrieve the data from the other cube. ...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 28, 2008 at 6:28 am
Not really understanding the issue completely and the steps that you are doing to get at your end result. Could you try and clarify this a bit. You...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 27, 2008 at 2:19 pm
Still not certain why you would have to create a second cube just to get the ORG_NAME. This seems to me like a simple modification to the Data Source...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 27, 2008 at 2:14 pm
If you have the org id in the cube already then I would assume you have the dimension that has the related attributes to this id value. Could it...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 21, 2008 at 7:06 am
Just wanted to remind you, and I am not sure how you are using this measure, but now that it is a calculation you will not be able to use...
----------------------------------------------------------------------------------------
Dan English - http://denglishbi.wordpress.com
October 16, 2008 at 4:51 am
Viewing 15 posts - 316 through 330 (of 341 total)