Search results for query: *

Hi, I am trying to build a report that shows, by month, the comparison to last year's figures so: April May June ---------------------------------- 2009||2010||2009||2010||2009||2010 ---------------------------------- 10 || 20 || 20 || 10 || 10 || 20 My data source is a...

Hi, Thanks for that, it works to a certain extent insofar as it splits out the Unmapped spend. However, the totals for Mapped spend are the overall total e.g. total spend = 100, unmapped = 20, mapped = 100!! What is happening there!? Logically it looks like it should be 100,20,80... Cheers David

Hi, I am building a report off a powercube and need to group data in a crosstab to identify whether something has been mapped or not. Unmapped items are assigned an 'Unregistered' Id so I have tried to create a data item that uses an IF statement for: if([CPD_Cube].[All Suppliers].[All...

I've had a request from our community of Query Studio users for Top (x) Reporting out of Query Studio. I know this is available through Report Studio (and we do use it there) but I was wondering if anybody knew of a way of doing it in QS. Cheers David

Hi, I have produced a chart based on a Moving Annual Total with months along the X Axis. Obviously, the data is not useful for the 1st year as it has not accumulated the 12 months required so I want to exclude this first year from the chart. Is there an easy way of doing this, when I try and...

Hi, I have a package based on a DMR model and have been requested to deliver a report showing Moving Annual Total by Customer Sector and Month (i.e. Months along the x Axis with the Sectors as the series in a line chart). My first attempt based off standard MDX syntax was rejected, any ideas...

Hi, I followed the IBM instruction for creating a YTD data item for my reporting purposes, which is working well. However, I want to be able to implement LAST YTD and similar functions. Whenever I try, using either the parallelperiod or prevmember functions (as these seem most useful) I get...

Well, this is embarrassing! I built the framework the report is based on - what did I miss!?

Hi, I have a top 5 customers report by contract that is filtered on year and category. There are some contracts for which there has been no spend at all this year but that had spend last year and vice versa. When I run the report, all contracts come back regardless of whether there has been...

Hi, I have two prompt boxes for year and month with month cascading from year. To make this work, I have included a reprompt button on the prompt page which is clicked after the year is selected to populate the month box. I was wondering if there is any way of putting a html item on the page...

I have prompts running from my time dimension for financial year and month (to get YTD and MTD figures). When I try to cascade from the year down to month, it sometimes greys out the month box and disables it (although this doesn't happen all the time, it does happen a lot of the time). If I...

Hi, I have a list report based on DMR which has two columns for Category and Customer Sector with spend and target information data shown. The category and customer information is hierarchical and I have enabled drill up/down on the report. What I need is the ability to specify that when a...

I've got that working now... New problem! I have prompts running from my time dimension for financial year and month (to get YTD and MTD figures). When I try to cascade from the year down to month, it sometimes greys out the month box and disables it (although this doesn't happen all the time...

I need to display on a report for a given business category both the amount of spend in a selected month and also the YTD spend up until that month (i.e. Business Services has spent £400k in January and in total £2.3m between April and January (financial year to selected date)). I am currently...