Viewing 15 posts - 316 through 330 (of 340 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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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. ...
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...
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...
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...
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...
October 16, 2008 at 4:51 am
Viewing 15 posts - 316 through 330 (of 340 total)