Recent content by Recce

Good day, I need to automate a few MDX scripts. Could anyone tell me which is the preferred way of doing this since I'm new to MDX. Thank you ... [pipe] "We know nothing but, that what we know is not the truth..." - Me

Good day, Would anyone be able to tell me if one can put a URL inside a Cube when you use it in Excel. In other words, when you build the Cube in SSAS,is there a way to indicate that the field should show as a URL in Excel ? [pipe] "We know nothing but, that what we know is not the truth..." - Me

Good day, I would like to know if anyone can help me with a select inti query. I am working on a Network Server and would like to write a select into query which should insert some data into a table on my local server. I thought it would look something like this however, this does not seem to...

Good day all, Hope someone can help with this question of mine... When I view my Client dimension in Excel the it dislay the Atribute as Client.Client Name. I would like to know how and where in SSAS di I remove the Client. part ? Thank you all [pipe] "We know nothing but, that what we know...

Thanks xlbo, Yes, I agree, that is my experience as well with SSRS but, it still creates awesome reports. Can't help it but, I'm a Microsoft fan...Yes,yes, I know :-) [pipe] "We know nothing but, that what we know is not the truth..." - Me

I thought that was going to be your reply :-) ... Not too sure how to go about the parameter part but, I have worked with the Report Viewer Control in the past. I'll see if I can find an example of the parameter part and query string on the web... Thanks RiverGuy [pipe] "We know nothing but...

Good day, Can anyone tel me if it is possible to create a TreeView menu strucure within Reporting Services so that it works similiar to one that you would create in an Web page ? [pipe] "We know nothing but, that what we know is not the truth..." - Me

Hi all, I need to create a custom scale fill colour for a gauge. I am experiencing difficulty to find examples on this. I need to assign 3 different colours to the scale of a gauge by making use of a custom function. Can anyone point me in a direction of where I can find some examples on...

Can anyone say if it is possible to change the colour of the folders that one create in order to group Measure's and Dimensions in Analysis Services ? When you view the folders in the Cube within Excel it has an orange like colour but, I would like to know if one can change that ? [pipe] "We...

Hi RiverGuy, Thanks for the reply.... I'll have a look at that example. Regards [pipe] "We know nothing but, that what we know is not the truth..." - Me

msasnewb, You should be able to do this calculation in SSAS. When you open the Cube there should be a tab within the Cube with the name Calculations. You can create the calculation there and that should then form part of your measure group. Regards [pipe] "We know nothing but, that what we...

Good day, I need to put a Target in a Cube however, the question that comes to mind is: Where does the target belong in a Cube. Do you make it part of the Measure Group or do you make it a Dimension. What is the standard or the correct way of implenting this ? Regards [pipe] "We know nothing...

Thanks, I'll have a look at this ... [pipe] "We know nothing but, that what we know is not the truth..." - Me

This is interesting...Thanks George. It works well ! [pipe] "We know nothing but, that what we know is not the truth..." - Me

Yes,that should be fine. I'm willing to add one or two... [pipe] "We know nothing but, that what we know is not the truth..." - Me