Reporting

[former_member211812]

Hi Experts,

Years-wise-->Time

Month-wise-->Category

Week-wise-->Report

1.My Current financial Year is-->April to March.

2.Suppose JUNE is my current month,

    then March,April,May is the actual values(Week-wise).

3.Here i have created 11 forecast like

{ July_Forecats

  Augest_forecast

  sept_forecast

  oct_forecast

  Nove_forecast

  Dec_forecast

jan_forecast

feb_forecast }

4.User Will select Year -wise time & Month-wise Category like.

1.My Current financial Year is-->April to March.

2.Suppose JUNE is my current month,

    then March,April,May is the actual values(Week-wise).

3.Here i have created 11 forecast like

{ July_Forecats

  Augest_forecast

  sept_forecast

  oct_forecast

  Nove_forecast

  Dec_forecast

jan_forecast

feb_forecast }

4.User Will select Year -wise time & Month-wise Category like.

5.Reporting is at week-wise.

[damovand]

Mr. Qureshi,

Please provide feedback or close a thread when you receive helpful answers.  It helps all other people who use this forum to find information.  Thank you

Best Regards,

Leila

[former_member186338]

Sorry, but it's absolutely unclear what do you want to achieve!

And please, close many open discussions you have...

Vadim

[former_member211812]

Hi Vadim,

My main intention is to generate the weekly report,

For which user will enter the time in year in EPM context.

and he will select the Category.

If the Category is actual then it should show actual values till the current month.

if the Category is budget then it should show budget values till the current month.

BUT for forecast i have created 11 forecast category

{ July_Forecats

  Augest_forecast

  sept_forecast

  oct_forecast

  Nove_forecast

  Dec_forecast

jan_forecast

feb_forecast }

and report should come at week bases.

Thanks in advance.

[former_member186338]

Still absolutely unclear!

Can you provide a real screenshot of the administration of your TIME dimension?

Vadim

[former_member211812]

Hi Vadmin,

what i am trying to say i want an dynamic report  the user selects the FY year from Context  category as forecast for Particular Month  and report

shall be displayed week wise

i have year as Financial Year (April - March)

the user will select the financial year say (2015-2016)  and  category as forecast (July_Forecast)

then the user will be able to see the report as Week wise (from month April to June 2015 )  as Actuals

and the remaining  as Forecast (week wise from July to march 2015 )

and when user select Category as Forecast (august_Forecast) for the same FY-2015-2016

then the reports should be as Week wise (from month April to July 2015 )  as Actuals

and the remaining  as Forecast (week wise from July to march 2015.

for your reference i have attached the time hierarchy for the same

Message was edited by: Mohammed Toufiq Qureshi

[former_member186338]

OK, the structure of your TIME dimension is clear. But the report requirements are still unclear

Please describe exactly what you want to be selected by user (with a sample selection)

And provide a desired report screenshot.

Then - second selection and second screenshot.

By the way - what is the logic in the relation between months and weeks? In real life you don't have a relation Do you use artificial weeks? Or months?

Vadim

[former_member211812]

Hi vadim

Thanks for your valuable time.

EPM CONTEXT TIME [ 2014-15]

CATEGORY [JUNE_FORECAST]

Now the report should be displayed as all weeks of April and may as actuals and the remaining months as forecast i.e.. is till march, this should also be in week wise forecast.

[former_member186338]

Do you understand me?

"Please describe exactly what you want to be selected by user (with a sample selection)"

What is "2014-15"??? I do not see this member in you time dimension screenshot!

"And provide a desired report screenshot."

All columns!!! Not a part of the report!

"Then - second selection and second screenshot."

Second report to understand what is the relation between user selection and report layout!

Vadim