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: *

  1. Revelator80

    Comparing Year on Year Performance by Month

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

    If statement with dimensional data source

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

    If statement with dimensional data source

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

    Top (x) Reporting in Query Studio

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

    Restrincting the X Axis on Line Chart

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

    Moving Annual Totals in Cognos 8.4

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

    parallelperiod/prevmember functions

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

    Issue pulling back relevant data only

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

    Issue pulling back relevant data only

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

    Javascript - automtic reprompt on drop down selection

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

    Cascading date prompts issue with DMR

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

    Drill Down Behaviour Question

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

    YTD Spend Total in report

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

    YTD Spend Total in report

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

Part and Inventory Search

Back
Top