If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how should I get current week number

Started by jd, 02 Feb 2009 11:29:47 AM

Previous topic - Next topic

jd

how should I get current week number?

Ex: my fiscal year starts from July, this is my 31st week. when I am pulling week to report it is giving all weeks 1 to 53. I want to see only this week number =31. to get all fiscal weeks  I am using YTD filter.

Thanks in advance.

sgotike

Can't you use the function  _week_of_year  ?

jd

Hi,
I am not sure how to use it.
I have fiscal week  and fiscal week start date in my model.

Please could you explain me how to use week_of_year function.
when I use it can I see from 1 to 31 weeks data.

Thanks in advance.

blom0344

Fiscal years that run heavily out of synch with a calender year demand an appropriate date/calender table. This way you will not have to recompute over and over again. Once you have populated the calendertable you can reuse it (using shortcuts in the model) for fiscal calcs..

sgotike

Is this in a package? Is it a query item?

jd


sgotike

I am not sure if I understand your question, but anyway let me try

Is this a date field like Jan 1, 2009?
You can edit the query item to a week number or you can create an extra query item based on the fiscal date.

For example if you want to convert the fiscal date to week number:
Double click the query subject, select the fiscal date query item, right click, select edit query item and add before the item  _week_of_year (, and add the ending ')'.

For example if your query item name is fiscal_date, and your query subject name is fiscal_dim and your source is fiscaldb, it would look like this:

_week_of_year([fiscaldb].[fiscal_dim].[fiscal_date])

this will convert the fiscal date to the week of the year.