Quick question : Year from 2010 and month from June

[Former Member]

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

[MariannevL]

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

[Former Member]

Hi Marinne,

HI ALL

Where i need to create this query can you tell me clearly is it in Variable Editor or formula editor and need to create new dimension?

I don't want use it in filter because few of the tabs in report needed from 2009

I am trying to create another tab in my report from 2010 June , And i will create Chart also with that.

And one more question is In my chart 'X' axis i am having months like from jan to dec.

I did custom sort but still it is coming like disorder (like Aug , Sep, JUL,oct etc) in chart ...But in report it is coming in Proper order.

Thanks in Advance

VJ

[former_member817653]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[former_member817653]

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.