Populating Attributes from Elements
Posted: Tue Apr 13, 2010 7:43 pm
Hello,
I would like to be able to populate an attribute based on a list elements and be able to update this each month.
Scenario:
I would like to be able to capture all active projects so I created an element called "Active Projects Text". This measure is a String and is populated with either "active" or "non-active" based on a Rule.
I created a TI process which has included parameters (vmonth,vyears) to capture the specific month and year, which can updated each month using an action button.
Within the TI Rule below the "vClient_Project" is the list of projects I would like to retrieve from and update the attribute in this dimension.
the rest of the variables are static to capture the data.
CellGetS('Project Forecast',vClient_Project,'Actual','CAD($)','Total Contractor-Employee',vmonth,vyears,'Active Project Text');
AttrPutS ('Active','Client-Project',vClient_Project,'Active Projects');
Lastly, when I change "vClient-Project" to a specific project it populates the attribute field, but doesn't work when I want to select the whole variable .
Hopefully that makes sense?
Thanks
Lance
I would like to be able to populate an attribute based on a list elements and be able to update this each month.
Scenario:
I would like to be able to capture all active projects so I created an element called "Active Projects Text". This measure is a String and is populated with either "active" or "non-active" based on a Rule.
I created a TI process which has included parameters (vmonth,vyears) to capture the specific month and year, which can updated each month using an action button.
Within the TI Rule below the "vClient_Project" is the list of projects I would like to retrieve from and update the attribute in this dimension.
the rest of the variables are static to capture the data.
CellGetS('Project Forecast',vClient_Project,'Actual','CAD($)','Total Contractor-Employee',vmonth,vyears,'Active Project Text');
AttrPutS ('Active','Client-Project',vClient_Project,'Active Projects');
Lastly, when I change "vClient-Project" to a specific project it populates the attribute field, but doesn't work when I want to select the whole variable .
Hopefully that makes sense?
Thanks
Lance