# Create report with Insight Object Attribute as Dimension

**URL:** <https://community.eazybi.com/t/create-report-with-insight-object-attribute-as-dimension/8166>\
**Category:** Questions & Answers\
**Tags:** insight, jira\
**Created:** [October 25, 2021, 2:34pm UTC](https://community.eazybi.com/t/create-report-with-insight-object-attribute-as-dimension/8166 "2021-10-25T14:34:12Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![omc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/o/f9ae1b/32.png) [@omc](https://community.eazybi.com/u/omc)\
**Post date:** [October 25, 2021, 2:34pm UTC](https://community.eazybi.com/t/create-report-with-insight-object-attribute-as-dimension/8166/1 "2021-10-25T14:34:12Z")

</div>

Hello,

I have in Insight the Object USER and it has a text field Attribute called CITY.

In the import options I can only check to import the attribute CITY as a Property, but on my report I want that attribute to be the dimension.

I want a report with one dimension, the CITY attribute, and with one column, the number of USERS (insight objects) with each CITY. Like following:

![image](https://community.eazybi.com/uploads/default/original/2X/7/781adf092fbf1e6e5bfe1276686d5a964ec5dcd1.png)

Thank you.

Best regards.

Alex.

---

<div class="post-metadata">

**Author:** ![roberts.cacus](https://community.eazybi.com/user_avatar/community.eazybi.com/roberts.cacus/32/637_2.png) [@roberts.cacus](https://community.eazybi.com/u/roberts.cacus)\
**Post date:** [November 3, 2021, 8:14am UTC](https://community.eazybi.com/t/create-report-with-insight-object-attribute-as-dimension/8166/2 "2021-11-03T08:14:54Z")

</div>

Hi @omc ,

Unfortunately, eazyBI can’t import text-type object attributes as dimensions. However, you can try to transform it as a select list type attribute.

The other option is creating a custom hierarchy in the _Object_ dimension, based on the attribute property. In such a way, you would have an upper-level “City” and “User” level members beneath it. See an example below on how to create the custom hierarchy:

 ![Screenshot 2021-11-03 at 10.09.35](https://community.eazybi.com/uploads/default/original/2X/7/77a4dedc284b247e1daaa6fef53cb8f09f23196d.png)

And how it would look in a report:

 ![Screenshot 2021-11-03 at 10.09.52](https://community.eazybi.com/uploads/default/original/2X/c/c830745fcecb2033ade298dafff2666e4dec3c7c.png)

Please see more details on creating custom hierarchies in some specific dimensions in eazyBI here - [Create reports](https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-AddcustomhierarchiestospecificJira,Confluence,andInsightdimensions).

Best,  
Roberts // [support@eazybi.com](mailto:support@eazybi.com)

---

<div class="post-metadata">

**Author:** ![omc](https://community.eazybi.com/letter_avatar_proxy/v4/letter/o/f9ae1b/32.png) [@omc](https://community.eazybi.com/u/omc)\
**Post date:** [November 4, 2021, 10:53am UTC](https://community.eazybi.com/t/create-report-with-insight-object-attribute-as-dimension/8166/3 "2021-11-04T10:53:32Z")

</div>

Hello,

It solved the problem. Thank you very much.

Best regards,

Alex.