Read the cube value in the process widget by using the template snippet

Hi there,
It’s probably have the capability to show the cube value with snippet by tm1-ui-dbr or anything that as one of the parameter in th process widget?

I tried the code like this but it failed…

<pf-form-group-apq
ng-if="param.name=='pBUDAmount'"
pf-label="Program Budget" required pf-label-class="col-sm-3" pf-input-class="col-sm-9">
<tm1-ui-dbr-apq
    tm1-instance="UX Demo" 
    tm1-cube="Program Master"
    tm1-elements="
    {{$ctrl.settings['UX Demo.Department.Department']}},
    {{Program 1}},
    {{Original Balance}}"
    ng-model="$ctrl.finalParameters[4].value">
</tm1-ui-dbr-apq>
</pf-form-group-apq>

Thanks!

Yes this is definitely possible to pull out a value and display it with the html-before or html-after section. However, I’m not sure that the value would respond to a change in the parameter subnm selection (I would actually guess that it wouldn’t).

As an alternate design you could split to separate widgets all embedded in a dashboard.

  • a “navigation” widget to make the from/to selections (Or even just a normal grid widget with hyperlink to chnge filters enabled only showing 1st column)
  • some single cell DBR widgets to show the current values being copied/replaced
  • A embedded TI widget to run the allocation that just takes the setting service value with entry disabled from the navigation widget

Hi All you need to do is ng-if the container once you have all the dynamic values populated

<pf-form-group-apq 
ng-if="param.name=='pBUDAmount' && $ctrl.settings['UX Demo.Department.Department'] && Program 1 && Original Balance "
pf-label="Program Budget" required pf-label-class="col-sm-3" pf-input-class="col-sm-9">
<tm1-ui-dbr-apq
    tm1-instance="UX Demo" 
    tm1-cube="Program Master"
    tm1-elements="
    {{$ctrl.settings['UX Demo.Department.Department']}},
    {{Program 1}},
    {{Original Balance}}"
    ng-model="$ctrl.finalParameters[4].value">
</tm1-ui-dbr-apq>
</pf-form-group-apq>

[/quote]

1 Like

Thanks for all the replys. And thanks for Alex. I found something cooler with using

 <tm1-ui-dbr-hidden
            tm1-instance="ApliqoFPM"
            tm1-cube="MyCube"
            tm1-elements="{{$ctrl.settings['ApliqoFPM.FIN CoA Map.FIN OCoA']}},{{$ctrl.finalParameters[3].value}},String"
            ng-model="$ctrl.finalParameters[4].value">
</tm1-ui-dbr-hidden>