Display results per week for given month

[Former Member]

hi all...

here i have a query... which displays the sales figures for the given period(fiscper).

i need to display the figures on weekly basis for the given period(fiscper)...

can anybody give me the solutio...

variables: period. example: december

result should be like

december

week1 week2 and so on.. and total/month

can anybody tell me how to achive this...

thanks

regards

nithin

[Former Member · Accepted solution]

Hi,

I suppose that your data in the cube is as follows:

ex:

custid 0calmonth 0calweek sales

c100 032005 132005 200

c101 042005 172005 100

If so you can add the 0calweek in rows of Bex query designer and as per the variable value of 0calmonth all the weeks of that month will be displayed.

shylaja

[Former Member · Accepted solution]

thank you man...

it has solved some thing...

still the problem is...

the user wants to see the results specific to one country.

anyhow i'm working on that.. it would be greatful to you if you give me help when i needed...

thank you man..

regards

nithin

[former_member188325 · Accepted solution]

Hi Nith,

U can use Country characteristc in Filter area and restrict characteristic with that specific country if country is same always..if u need to have dynamic ...then create a variable on country.

Thnaks

[Former Member]

Hi Nith,

can you tell me how did you split the month into weeks, as i have the same req at the client.

Thanks

[Former Member]

sure mate!!!

shylaja.

[Former Member]

hi all...

pl help me to find the solution...

thank you

regards

nithin

[Former Member]

Hi,

If you dont have 0calweek in your Info cube., you can load the cube data into other Infocube which has 0calweek and this info object is filled by using Time distribution option in update rules.

update rules> time reference>Time distribution

USE:

Source InfoObject for time distribution

The characteristic is filled by time-splitting from a time-characteristic from the communication structure.

For example, if the source-characteristic is the calendar month, and the target-characteristic is the calendar-day, each key figure that needs to be added up is split between the calendar days in this month.

You decide whether you use a factory calendar or the normal calendar.

reward if helpful..

shylaja.

[Former Member]

hi.. guys thank you very much for your help...

ya i have 0calweek in my cube...

but the requirement is user inputs only month.

based on that month it has to display results

like week1 week2 like that..

any coding help is highly appreciable...

waiting for ur input...

thank you guys..

regards

nithin

[former_member188325]

Hi,

Do you have 0CALWEEK in your Cube?

If so,may be it is possible with Customer Exit.

Thanks