Search results for query: *

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

...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 work: select * into [local].MyDB.dbo.Myserver Can anyone maybe suggest how I should change this in order to be able to select into my local server please from...

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

Hi everyone, I need to split a sentence into it's seperate words and those words can then be in their own columns. I have managed to split the first word by doing the following: SELECT BRANCHNAME, SUBSTRING(BRANCHNAME, 1, NULLIF(CHARINDEX(' ', BRANCHNAME) - 1, -1)) AS [FirstWord]...

Excellent ! Thanks for this combo... [pipe] "We know nothing but, that what we know is not the truth..." - Me

Good day everyone, I got some code in the forum on how to make 'n cell blink and it works good however, I am trying to use the same code to make a shape blink. I was hoping someone could help me to just structure the code correctly. Below is the code for the blinking cell in Excel and below...

Thanks for this RiverGuy. This interesting and I din't know this however,this fact table has 800 000 unique records which means that, there has to be another reason as well and I can not figure out what it can be... [pipe] "We know nothing but, that what we know is not the truth..." - Me

Good day, I am using Analysis Services 2008. I have enabled drill through on three seperate perspectives in one Cube. I have also set the maximum no of records to 150 000 in the SSAS Drill Through Action. This I have also done within the SSAS enjin properties. When I am in Excel I also make...