Has anyone created a blob for margin in the Cost Plan?

[Rick Morris]

We are trying to see margin on a month by month role by role basis.  We also want to add a contingency factor to the cost and revenue to account for risk that we want to see in the cost plan.  Has anyone done this before?  Looking to not recreate the wheel if possible.  Thanks!

[Kathryn Ellis]

The application will allow you to create Fiscal, Time-varying attributes that can be added to the Cost Plan Detail Object and placed on the List view in the TSV field.

There are 3 types of TSV attributes that can be created with 2 different calendar types ; however, it is recommended to only use 'Fiscal' calendar type of TSV and do not use the 'calendared' TSV for new attributes if you are going to use them with the stock TSV Fiscal attributes.

Use Fiscal calendar type and create a Money, Number or Percent data type attribute.

 

In the List View, add the attributes to the TSV and you can 'enter' data into the cells as shown in the example below

Enter the data into the cells

Click 'Save' and see the numbers :

[Rick Morris]

Thank you for the reply. Margin is Revenue - Cost. We have both of those fields, so we want the TSV to be calculated. We don't want to enter Margin in manually

 

Sent from my iPhone

[Kathryn Ellis]

You would NOT be able to create a new calculated attribute for use in the TSV. (perhaps log an idea to allow for a calculated TSV attribute as a new data type?)

In the TSV field, there is a Revenue Variance field -- I think it is for Planned Revenue vs. Actual Revenue.

[Rick Morris]

Correct.  The question then is can we create a gel script process that creates the BLOB to insert back the Margin.  Need Revenue – Cost, not Planned vs. Actual.

[Kathryn Ellis]

I am not sure about that because the BLOB field is not easily updated or read using standard SQL statements.

You can create new Fiscal TSV Attributes which are BLOB fields and sliced natively through the UI.

You could potentially use GEL scripting to READ out the plan using XOG ; update the custom TSV attribute SEGMENTS and WRITE it back in

Maybe that is a feasible idea?

Try it and let us know if this helps you.

[Anon Anon]

Hello Kathryn,

 

Is there an easy way to do this? (Update a new TSV Value using a SQL Query since the value cannot be updated via XOG.) We want to read the data for a specific "time period" on the TSV and write that value to a different TSV for the same "time period".

Kathryn Ellis wrote:

 

I am not sure about that because the BLOB field is not easily updated or read using standard SQL statements.

You can create new Fiscal TSV Attributes which are BLOB fields and sliced natively through the UI.

You could potentially use GEL scripting to READ out the plan using XOG ; update the custom TSV attribute SEGMENTS and WRITE it back in

Maybe that is a feasible idea?

Try it and let us know if this helps you.

[navzjoshi00]

Has anyone done as stated or can throw some light on the steps ?

 

"You could potentially use GEL scripting to READ out the plan using XOG ; update the custom TSV attribute SEGMENTS and WRITE it back in"

 

NJ

[C.J]

Morris,

 

Did Kathryns information work for you and is your problem resolved? If so if you could mark her answer correct we would really apprecaite it.

 

Thanks

CJ

[Rick Morris]

It is still unanswered.  The original question is if anyone has created a blob crack so that I can do Revenue-Cost and insert that as Margin through a process.

 

Rick

[Kathryn Ellis]

You would have to compute it from the slice values for Revenue and the slice values for Cost and put in a report or portlet query.

You won't be able to create a computed TSV field as noted previously.

[navzjoshi00]

Has anyone done as stated or can throw some light on the steps ?

 

"You could potentially use GEL scripting to READ out the plan using XOG ; update the custom TSV attribute SEGMENTS and WRITE it back in"

 

NJ