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

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...

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...

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...

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]...

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...

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...

Good day, I was wondering, if I have a slowly changing dimention which makes use of a view in SQL server then, would there be a way to only update that specific dimension sy once a day but via SSAS and not in SSIS or on the DB. In other words would I be able to only update that dimention when...

Good day, I made use of the Excel Ribbon option which is available in Visual Studio to create menu options in Excel. Now, I have a question. Within that Ribbon which I created I have a help file (.chm) and, I would like to know if it will be possible to create a shortcut key that will launch...

Good day, I was wondering if anyone can give me some insight as to what the best practice is when working with SSAS. Currently we have SSAS on a server that house the DB as well. Also,on the same server we have SSRS. I was wondering if we would get better performance from SSAS if it was on...

Good day, I have 'n varchar field in SQL server which gives me time bands. The problem I have is to neatly sort them in SSAS. This is what the time bands looks like. Can anyone maybe make a suggestion as to what I can change to neeatly order the result in my Cube so that it reads in sequence in...

Good day, I was wondering if it is possible to use the MDX query that gets generated in the back of the Pivot Table in Excel to create a SSRS report ? In other words,I would like to know if I take the MDX query can it be used in something like a DrillThrough action to automatically generate a...

Good day, I would like to know if anyone can tell if it is possible to monitor or track the way as well as how often users access or use their dimensions in a Cube ? [pipe] "We know nothing but, that what we know is not the truth..." - Me

Good day, This may be a funny question or situation but, to me its a real problem and I am not sure where or in which forum to discuss this. I was hoping someone could make a suggestion. I am working in a BI team for a company with approximately 1000 people. We do the usual Business...

Good day, Currently we have 22 Cubes running within Analysis Services. We are now starting to experience problems with our Cubes in the sense that some of them fail during processing which,never used to be the problem in the past. I was wondering if anyone would be able to say if this is...

Good day. In our company there are many Cube's in Excel files that have Cubes in them with old OLAP.3 connection strings. The problem is that currently we use OLAP.4 connection strings when we setup Cubes in an Excel. Some of the older Cubes are beginning to give problems and need to be moved...