AnsweredAssumed Answered

Simple Cost Plan Details NSQL query?

Question asked by JoostBreggeman76041091 on Nov 7, 2015
Latest reply on Nov 17, 2015 by JoostBreggeman76041091

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

 

 

OctNovDec
Project x200001000015000
Project y50001500025000
Project z3500200012500
Totals285002700052500

 

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

Outcomes