Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Recce
  • Content: Threads
  • Order by date
  1. Recce

    Automating MDX

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

    URL inside the Cube ?

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

    How do I select into (local) ?

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

    How do I remove the ClientName.Client in my dimension ?

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

    TreeView menu structure ?

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

    How do create a Custom scale colour for a Gauge ?

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

    Is it possible to change the colour of the folders ?

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

    Where does Targets belong in a Cube ?

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

    Splitting a sentence into words ?

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

    Blinking Shape ?

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

    Drill through return random sets of row counts ?

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

    Slowly changing dimention...

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

    Shortcut key to launch help file ?

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

    SSAS on its own or on the same box as the DB ?

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

    How do I order this varchar field ?

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

    Can MDX be used to create a SSRS report ?

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

    Monitoring Dimension Usage ?

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

    Business Intelligence,now what ?

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

    How many Cubes on Analysis Services ?

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

    Changing old .odc to new .odc

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

Part and Inventory Search

Back
Top