Hello!
I have an issue, I am trying to count a series of objects with certain conditions. I have around 150,000 objects, and I am attempting to filter them by type, but no data is appearing. If I try to perform operations with these 150,000 objects, eazyBI crashes. I am trying to access the ‘children’ of the hierarchy within the object type. I am attaching screenshots to provide a better understanding
Hi @csantosb,
You were on the right track for the measure “empty Date”.
The method “.Members” displays members of the hierarchy at the given hierarchy level.
However, in your case - you are looking for the dimension “Object Type” members included in the calculated member “All Tools”.
So, in your case, you need to look into the calculated member, and you might use either .ChildrenSet method or DescendantsSet() function to create the set of members included within “All tools”.
The expression for creating the set of Object Types included in “All tools” might be as follows.
a) addressing children of a specific calculated meber
[Object Type].[All Tools].ChildrenSet
b) addressing children of calculated member from the current report context (either on report pages or rows)
[Object Type].CurrentMember.ChildrenSet
c) addressing descendants on a specific level from a calculated member or selection in the current report context (either on report pages or rows)
DescendantsSet(
[Object Type].CurrentMember,
[Object Type].[Object Type])
I suggest using the third option as that provides the most flexibility.
Then you might address the current member during iteration as [].CurrentMember
Another point I noticed - the calculated member “All Tools” within the dimension “Object Type” uses equation to check the Object Type.
As a result - it might actually only return one item - “Tool”. You might check that by clicking on + in the table next to the “All Tools” entry.
If you look for all “Object Type” members that include the word “tool” in the Object Type name, you might use the following expression.
Aggregate(
Filter(
[Object Type].[Object Type].Members,
[Object Type].CurrentHierarchyMember.Name MATCHES "tool"))
This should include “Engineering Tool”, “Reporting Tool”, “Tool” and “Toolset” as well.
After that, the “Empty date” measure would only succeed in filtering Object Types if “Disabled Date” and “Archived Date” are set on “Object Type”.
Then you would need to add either Count() function on top or do other activities with the created set of Object Types.
A very similar approach is needed in the AllStatus measure.
The used measure “Status” works fine for an individual object.
So you might decide if you want the “AllStatus” expression to look into the childrenset of a specific “Tool” category of Objects or if it should consider the current context - the page selection and the current row.
I suggest using the following expression for AllStatus as that will consider the whole context.
Sum(
Filter(
DescendantsSet(
[Object].CurrentHierarchyMember, [Object].[Object]),
[Measures].[Status]="Ativa"),
[Measures].[Objects created])
Regards,
Oskars / support@eazyBI.com