Clarity

  • 1.  Simple Cost Plan Details NSQL query?

    Posted Nov 07, 2015 04:52 AM

    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



  • 2.  Re: Simple Cost Plan Details NSQL query?

    Posted Nov 07, 2015 03:04 PM

    Your question is similar to

    Whitch slice request to use for getting the Unit value from Project BUDGET plan

     

    Whitch slice request to use for getting the Unit value from Project BUDGET plan

    There is more information in the links.



  • 3.  Re: Simple Cost Plan Details NSQL query?

     
    Posted Nov 16, 2015 02:45 PM

    Hi Joost - Did Martti's response help you resolve your issue? If so please mark as Correct Answer. Thanks! Chris



  • 4.  Re: Simple Cost Plan Details NSQL query?

    Posted Nov 17, 2015 04:57 AM
      |   view attached

    In the end our CA consultant created the overview. I haven’t reviewed the query yet, but as soon as I have I will share.

     

    Joost Breggeman

     

    Direct: +31 73 704 2165

    Mobile: +31 6 1500 3721