Search results for query: *

Hi Can anyone give me pointers on how to configure a machine so that it is possible to run .NET applications with Analysis Services? I will be using HTTP not HTTPS. Currently I have IIS, Visual Studio and the SQL Server Client connectivity tools. If I look at my installation I can see 2...

Hi all, I am a relative newbie to the world of .NET and am trying to write an OLAP application using the ADOMD sdk - COM version. For example I am using the following statements in my code Imports ADODB Imports ADOMD Imports System.Data.OleDb Dim cn As New ADODB.Connection...

Hi I am trying to create an MDX query which will return the CURRENT YEAR year to date revenue value. I have spent ages with this and have so far ended up with the following: WITH MEMBER Measures.[Current YTD Revenue] AS Aggregate(PeriodsToDate([Date].[Fiscal Calendar].[Fiscal Year]...

Hi I am trying to return a query that will return just one cell showing the Quarter to Date revenue for the current quarter. I have defined a QTD Revenue calculated member and am then trying to return its value by referring to it in a subsequent MDX select query. Exact code used is shown...

Hi I am really struggling with something that I think ought to be simple... I need to change the colour of the background on all my dashboard pages (ie each page on my Corporate Dashboard). I have tried editing the main dashboard stylesheet and unless there is a very easy customisable option...

Hi I have this niggling issue that is really getting to me - as I have tried all sorts of things and nothing works. I have created a Universe to use in conjunction with the dashboard builder and in my DimTime dimension there is a field Month and a field MonthName. All I want to do is to tell...

Hi My query relates to the Microsoft 70-445 certification. My understanding is that the 70-445 exam is far from easy (not surprisitng since SSIS, SSAS and SSRS are all fairly substantial bits of software). I have also been told that Data Mining makes up to 20% of the exam so although I...

Hi Background I am currently on client site. Currently a set of financial reports within Navision are being copied into Excel where changes are made to them ie reformatting etc... The client would like all their reports to be done within Reporting Services because they want to have...

Hi I have been experimenting with creating my own Counter variables having read an interesting thread by 'Catadmin'. I am trying to create a counter that will return the Group Number. So far I declared a Shared Counter variable and have written 3 functions, one that increments the...

Hi, I am completely stuck so hoping somebody can help me... would hugely appreciate any input even if the answer is that what I am looking to do is not possible. Contextual Information I have a basic report with just a few rows and two groups. The report shows the number of peak and non peak...

Hi, I was wondering if anyone could provide any input into a particlar problem I have been having. I have been doing some work for a client designing and populating their datawarehouse. Just recently I have encountered a problem that relating to the use of fields with a decimal data type in...

Hi all, I have written a routine that creates a calendar that contains a list of dates (dating back from 01/01/2000) and that assigns each date a Week Number, Month Name, Quarter and Year. The Issue I am having I simply use the function DatePart ie DatePart(wk,Table.Day) to assign a Week...

Hi, I am looking to create SQL that performs the reverse of a UNION statement. A table has been set up for me that contains a list of week start dates (starting on a Sunday). The table tells you the week number each week start date relates to for a particular customer. WStartDate...

Hi Background Info I am currently in the process of writing code to load a Fact Table that stores information on supply and demand of crops for a company that sells bouquets of flowers. The code I had originally written to do this was a mess of many temporary tables all bunged together...

Hi everyone, I have a requirement to build 3 cubes for a company which sells bouquets of flowers to different retailers. Describing the issue The client would like one of the cubes to be designed in a way so it makes use of multi-calendars. The client has a handful of customers who each...

Hi, I have a customer that wants a cube that displays 52 weeks worth of future data ie 52 weeks after the current date and 2 weeks of past data ie 2 weeks before the current date. Problem is, I have no way how to find an OLAP solution to this. I have searched the web but can find nothing...

Hi, I do a lot of on-site client work. I just wanted to get some general advice on something. Suppose a customer asks for some cubes to be created. If it is clear that the star schema created to source these cubes would have no function other than to serve these very same cubes then would...

Hi I have a problem with Time and am wondering if anyone could be of any help... I am working on a cube that has a Calendar Date and Fiscal Time Dimension. I have written a SalesYTD Calculated Member (under Measures) with the following MDX code: Sum(YTD(),[Measures].SalesAmount) This...

Hi everyone, The Background I have been asked to add some 'to date' time analysis to a cube developed by one of our clients. This cube has two measures: Invoiced Amount Units Sold The client wants to make Year to Date and Month to Date comparisons for both these numeric values...

Hi, I am on a client site and have been asked to help speed up some reports. On one particular report the user is asked to enter two string values: Start Period and End Period . These 2 string input values then get converted into numbers: 200401 represents May 2003, 200402 represents 200402...