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

Actually doesn't appear to be giving me the right results - appears to be summing future dates as well.. Oh no! Help anyone ? [sad]

Ok I think I may have resolved this myself... I have come up with this query to return a Quarter to Date measure. WITH MEMBER [Measures].[QTD - Days - Worked] AS 'Sum(PeriodsToDate([Date].[Fiscal Calendar].[Fiscal Quarter]),[Measures].[Days - Worked])' SELECT ([Measures].[QTD -...

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

Thanks for the reply. I did get this working but by using an object format as I couldn't get the SQL way to work...

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

Thanks Geoff, Its strange as when I typed in the code the editor didn't like it (had 'Code.Counter' underlined in red, but I ignored this and find that it does actually work when I run the report. Great news. Thanks again for very quick reply! Nassy

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 SQLWilks, Thanks for replying so quickly. I could just put the titles in the report header and then they will appear once only but they will appear above the groupings. I am very new to Reporting Services and am exploring what it can and can't do and wanted to see if I can conditionally...

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 everyone, Thanks for the responses. Luckily the way the client wanted me to specify a week made this very straightforward. They always wanted week 1 to start from the last Sunday of the previous year unless the new year happens to start on a Sunday. Therefore it was a simple case of...

Thanks - these articles are what I'm looking for. I will have a read through them. cheers Nassy

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

Sorry for the very late response. The customer calendars are all based on a standard calendar - it is just the sequence of the weeks that changes. The week always starts on a Sunday. For example: 05/03/2006 might be week 9 on the normal calendar but for customer A could be fiscal week 12 and...