Grid Portlet with monthly Actuals/ ETC Values

[Anon Anon]

Hi, I'm trying to create a custom portlet to replicate this attached example.

I need to get Actuals/ ETC information from my projects but I need to get the info divided my months.

Can you give me a clue on how do I get that. I suppose time slices will be involved but I have no experience working with them.

All ideas are much welcome and appreciated.

Thanks again,

Juan

[navzjoshi00]

For ETC, you can use the below slice -

ID REQUEST_NAME
113
M_ETC

For Actuals, you can use the below slice -

ID REQUEST_NAME
4
MONTHLYRESOURCEACTCURVE


NJ

[Owen_R]

It's not quite what you want, but you could also look at the portlet OBS Investment Aggregation - I've configured it here to show actual and ETC. Other metrics are available in it. To get the SQL you will need to run a SQL Trace as it's a hidden data provider.

If you want your portlet to show actuals and ETC as separate sub-columns within the month column, then you need a multi-dimensional portlet I think.

Owen

[Deactivated User]

What do you need to get the portlet OBS Investment Aggregation populated?

Martti K.

[Deactivated User]

For creating monthly columns in a query based portlet see

101028616

and for having two different attibutes in one set of timsecaled columns

98119889

Martti K.

[Owen_R]

another_martink wrote:

What do you need to get the portlet OBS Investment Aggregation populated?

Martti K.

A very quick SQL trace shows that it's getting periods from NBI_DIM_CALENDAR_TIME so datamart must have run at least once. Investments must be associated to an OBS, although the data is from insta-slices not the datamart. Given you can filter by resource OBS within the portlet, then resources must also need to be associated to an OBS.

[Deactivated User]

Thanks.

Looking at the v12 Sandbox that portlet is not populated.
Unfortunately you do not have currently login to that.

Martti K.

[Anon Anon]

Thanks Guys. I think I might be going with the Multi Dimensional Query