Periodic model not fetching YTD data

[paliwalamit9]

Dear experts,

I have a periodic model where I am trying to fetch YTD data in a report.

I have maintained TIMEID correctly

Also Periodic to YTD and YTD to periodic is working for all other models, only not working for specific model.

[former_member190501 · Accepted solution]

Hi,

Compare your measures formula using UJA_MAINTAIN_MEASURE_FORMULA with other models which are correctly showing the results.

Hope it helps..

Regards,

Raju

[paliwalamit9 · Accepted solution]

Is this program model specific?

As far as I know this is universal

[former_member190501 · Accepted solution]

Yes!..its model specific. Just run this program and see the selection screen

[paliwalamit9 · Accepted solution]

Yes. I checked the formulae.

There was some difference. I made the changes in those formulae (i.e. i copied the correct formulae)

Do I need to run any process after this?

[former_member190501 · Accepted solution]

No need to run any process....just logoff form Excel and login to see correct results.

[former_member186338 · Accepted solution]

Hi Amit,

By the way, what was the difference?

Vadim

[paliwalamit9 · Accepted solution]

Hi Vadim,

Insted of SUM(PERIODSTODATE([%TIME%].[%TIMEQUARTERLEVEL%] it was SUM(PERIODSTODATE([%TIME%].[%TIMEYEARLEVEL%] for QTD and vice versa for YTD.

Regards,

Amit

[paliwalamit9 · Accepted solution]

HI Raju,

Tried the same. Still the problem persists

Regards,

Amit