How to get the value of Attributes Object of insight

Questions & Answers
1

Hi

I have made dozens of reports through eazyBI, which are statistics of the number of existing objects of insight, and the results are very good. But I recently tried to make some reports to show the attributes of individual objects, and I encountered problems.

For example: I have a Location Object Type and Company Object Type in insight. Location Object Type has three Attributes, two of which are default “Address-Text” and “Latitude-Float”, and the third is a reference to Company Object Type.

By default propertyties of mdx in “Calculated members” of Measures

[Object].CurrentHierarchyMember.get('Location Address-Text')

[Object].CurrentHierarchyMember.get('Location Latitude-Float')

[Object].CurrentHierarchyMember.getLinkedMemberNames(
  'Location Company-Object', Chr(10)
)

I can get the values of insight whose Attribute type is Default (Text-Import as property and Float-Import as property & measure)，but I can’t get the values of insight whose Attribute type is Object (Import as property & dimension),it Suggest failure：

Child process request failed with Net::ReadTimeout:
The child process will be restarted now, please retry the request in a minute.

or

Query execution timeout of 60 seconds reached.
Please try to make query simpler.

If I by default mdx of " Define calculated member formula" in “Calculated members”

[Measures].[Object Location Address-Text]
[Measures].[Object Location Latitude-Float]
[Measures].[Object Location Company-Object]

I can get the values of insight whose Attribute type is Default (Text-Import as property and Float-Import as property & measure)，but I can’t get the values of insight whose Attribute type is Object (Import as property & dimension),it Suggest failure：

Child process request failed with Net::ReadTimeout:
The child process will be restarted now, please retry the request in a minute.

or

Query execution timeout of 60 seconds reached.
Please try to make query simpler.

I’ve made other attempts：

[Object Location Company-Object].CurrentMember.Value

Formula is not valid:
Java heap space

[Object Location Company-Object].CurrentMember.Members

Formula is not valid:
GC overhead limit exceeded

[Object Location Company-Object].CurrentMember.Name

Formula is not valid:
GC overhead limit exceeded

[Object Location Company-Objec].CurrentMember.Name

All Location Companys
(No member name is displayed)

[Object].CurrentHierarchyMember.get(' Location Company')
NW-27,NW-734151
(Correct insight key,No name is displayed)

Please help me to tell me what I missed.

1 Like
2

We suggest using default measures and properties whenever possible. You are using default properties for Objects. They work only if you are using Object dimension in the report.

In case you have many objects in the schema and a complex report using Object dimension, it could lead to timeout errors or out of memory errors.

I would suggest using default properties for objects in the report. Please use some dimensions on Pages for filtering. Use single value selections on Pages when possible.

Avoid using several dimensions on Rows if you are using Object dimension on Rows. Use properties from Measures to show some values for each object.

You can also check some recommendations for eazyBI performance optimization as well.

Daina / support@eazybi.com

1 Like