Hi,
I am trying to create a simple NSQL query to retrieve the following information from the Cost Plan where the Y-axis represent projects / investments per row and X-axis the months represented in the Cost plan details.
The content should provide the units / costs and or revenue
| Oct | Nov | Dec |
Project x | 20000 | 10000 | 15000 |
Project y | 5000 | 15000 | 25000 |
Project z | 3500 | 2000 | 12500 |
Totals | 28500 | 27000 | 52500 |
I started with a simple query to retrieve the Units (one-dimensional) but it gives me a blob like this: [B@3a5de9de
I used the following query:
SELECT
@SELECT:DIM:USER_DEF:IMPLIED:REV:cpd.plan_id:plan_id@,
@SELECT:DIM_PROP:USER_DEF:IMPLIED:REV:cpd.units:units@
FROM FIN_COST_PLAN_DETAILS cpd
WHERE @FILTER@
HAVING @HAVING_FILTER@
WHat do I need to do to get the information I need?
THanks
Joost