Issue with Timescaled Portlets

[Arunima Roy]

​I am trying to create a timescaled portlet where the cost (actual, forecast,budget) needs to be displayed in three lines.

cost type    Jan20    Feb20  Mar20
-----------------------------------------------
Actual       100        100       100
Forecast   200         200      200
Budget      300        300      300

From my query, I am getting the attributes (Actual, Forecast, Budget) as columns for all the months.
Please let me know how to create the portlet in the above mentioned format.

Regards,
Arunima

[David Morton]

I don't think we can build custom timescaled portlets based upon NSQL queries (only on stock data-providers with a timescaled element).

If this is a NSQL based query then building one with multiple dimensions might be the answer (data would still display in separate columns though).

Or just write the NSQL such that it delivers the data in a grid (as per your layout example) - three UNION'd statements could deliver the 3 distinct rows in your example.

[Arunima Roy]

Hi David,

Thank you for the reply. I am using multiple dimensions portlet and also using union in the query but still the output is in columns.

Regards,
Arunima

[Martti Kinnunen]

There is some discussion on that in
https://community.broadcom.com/enterprisesoftware/communities/community-home/digestviewer/viewthread?MessageKey=4864a697-5b52-4275-928f-b2c1603c8d47&CommunityKey=7f0cbca3-5f93-4d44-a369-1a8ce98f5578&tab=digestviewer#bm4864a697-5b52-4275-928f-b2c1603c8d47

[David Morton]

"I am using multiple dimensions portlet and also using union in the query but still the output is in columns."

Yes - and as I said you will always have that ; I don't think "timescaled" can be produced via NSQL as it relies on built-in tiimescaled data providers.

You can definitely produce output that looks like your example, but it will all be in rows/columns (just a grid of data).

[Martti Kinnunen]

Agreed with my skilled colleague.

Looking quickly at i, it could be something like

Sub query for actuals (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3
Union
Sub query for forecast (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3
Union
Sub query for budget (Subsubquery for Month 1, Subsubquery for Month 2, Subsubquery for Month 3