I would like to get list of analyses on elements without child elements.
Does someone done it before?
Thanks for posting on PI Square and welcome to the community.
Unfortunately, what you are asking for is not a feature of the analysis service. In our documentation (Rollup Analysis), there are 2 modes of operation:
1) Rollup of Attributes in a Single Element
2) Attributes of the element's child elements.
This makes sense as generally speaking, when you roll up either multiple attributes in a single asset (such as checking your mass and energy balances) or you are trying to get a summary value of all assets belonging to a group (such as average product flow for all reactors).
That being said, I can see value if you want to calculate a value for all assets belonging to a category or element template. Can you provide a use case as to why you can't rollup on child elements and calculating on the parent asset level?
A workaround is to create an analysis on a element that just references all all the attributes you wish to rollup from various elements. Analysis Service is capable to looking at values for attributes that belong to other elements. This workaround is valid as long as you're not pulling too many attributes as at that point, it's too cumbersome and a pain to configure.
Just to be clear, here is simple case:
-Child Element 1.2
-Child Element 1.3
-Rollup Analyses based on child element attributes
Rollup Analyses come from template of Child Element 1.3. Some of these Analyses based on Child elements attributes.
So all of them making errors because of that.
Need to find out all elements without child elements and having Rollup Analyses with errors.
Sorry for misunderstanding your request. Can you elaborate more on the error state? Are the analysis in error or are they running but writing Calc Failed?
They are in error, because it is assumed to have child element by template to run rollup analyses. In fact they are lowest level child element and does not have lower level in hierarchy.
I tried to do it with excel, have found elements with no children. But they are lot.
Then did search for rollup analyses in those element templates. Even this takes lots of time because there are varios templates used on mentioned elements. So you can imagine how it is complicated.
Another way would be just remove rollup analyses from templates, but it is not acceptable in our case because elements based on that templates could have child elements and analyses could be working there.
The easiest way would be to use PSE go to the Management Tab and filter based on status:
If the analyses are in error, they would be listed there. This should be a good place to start unless you have too many analyses in general in error to discern which analysis is which.
I would like to get only rollup analyses which are referencing to child elements attributes, but do not have child elements.
Thank you, Atkeldi
Retrieving data ...