Skip to Content
author's profile photo Former Member
Former Member

Quick question : Year from 2010 and month from June

Hi Guys,

I am taking year and month from Year(serverdatitime) (this time was recorded when employee starts printing).

Now i got Years: 2009,2010,2011 and months from jan to dec

But i only want from 2010 june to uptodate.

Can you tell me which query i need to use and how.

Thanks in advance

VJ

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 07:02 AM

    Form a numeric dimension with values of the format YYYYMM and then query for values greater than or equal to 201006.

    How to form a a dimension with format YYYYMM in universe depends on your data source.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 07:27 AM

    Hi,

    My suggestion is to keep your column format as it is. Just put filter for that object and greater than operator and choose the date (eg. june 2010). You will get the result after the date you specified in the filter.

    Regards,

    Ragoth.C

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 07:36 AM

    If you want to display all the record from 2010 onwards than better apply the condition in Query panel (Year Graten than Equal to 2010) of the reports. This will filter the record for whole reports.

    If you want to display only for the one column than go ahead with the column level condition.

    Hope this may help you out to solve your issue.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2011 at 11:05 AM

    Hi,

    For your requirement you need to concatenate both year and month object values to a single object i.e. Yearmonth and apply filter on it in report level.

    But for to work the some Yearmonth column should be there in Database

    Cheers,

    Suresh Aluri.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 22, 2011 at 04:12 PM

    Hi VJ,

    Since you post this in the WebI forum and ask for a query solution, I assume you do not have the option to change the universe.

    It really would be the simplest way to build the condition on a numeric yearmonth object.

    And it would be best to do the limitation in the query.

    So if you do not have this combined object in your universe you can either build the condition in parts...

            Year = 2010
        and Month >= 6
    or
        Year = 2011

    If you do not even have a numeric month object, you can only do...

            Year = 2010
        and Month in ('June','July','August',....,'December')
    or
        Year = 2011

    If you decide to do the filtering in the report you can make this combination numeric yearmonth dimension object yourself.

    And simply use yearmonth >= 201006

    Hope this helps,

    Marianne

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      In the scenario that you have stated, you need to create a dimension variable(using variable editor in the WEBI report) YearMonth in the report like this -

      =Year([DateDmn])*100+MonthNumberOfYear([DateDmn])
      

      Then create another measure variable Measure1 like this -

      =If([YearMonth] >= 201006) Then [Your_Measure] 
      

      Use Measure1 in the tab that you want to show data only beyond June 2010. In the properties of the table, uncheck "Show rows with empty measure". For the chart, uncheck "Show when empty".

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.