Error when changing entity relationships

MSugiyama

Even if I reconfigured the entity relationship, it was not reflected in the data view. The data is displayed in the data view with the original settings.

① Apart from the time entity, I created an entity named "Month Stamp". (Entity items include 202402, 202403, 202404, etc.)

②I created another entity named "Last month/this month status". (Entity items include this month, last month, and N/A)

③I set the parent of "Month Stamp" to "Last Month/This Month Status", set the parent of 202403 to last month, the parent of 202404 to this month, and the parents of other items to N/A.

④I reset the relationships and set the parent of 202404 to last month, the parent of 202405 to this month, and the parents of other items to N/A.

⑤ I reset the relationship settings, but this month's data displayed in the data view remained the same as 202403 before the settings were changed.

I think this is an error problem and am contacting BOARD support.

Regards,

MSugiyama

Shisong

Try normalize the entity hierarchy if you haven't done so.

In case you have a more than 2 layer entity hierarchy, say A → B → C, even if you set the relationship between A→B and B→C correctly, you still need to do a normalization to make the indirect relationship between A→C work. https://www.boardmanual.com/board14/data-modeling/data-model-design-sections/relationships/managing-relationships.htm?rhsearch=normalize&rhhlterm=normalize%20normalization

Federica Antonelli

Hello @MSugiyama,

A couple of questions to better understand.

I guess you are creating standard entities and not working with the custom time entity, right? Why did you create the "Month stamp" entity and not use the time entity month? If I well understood, what you need is a setting to identify which is the last and current month, correct?

Federica Antonelli

If this is the case, to obtain a dynamic "current month", I would suggest creating a cube "SET - Current month" with the MONTH dimension. With the Data Entry, you set 1 on the current month. Then you can use the time functions - Previous period value or the offset to identify the previous month.

Hope that this helps.

MSugiyama

@Federica Antonelli

Thanks for your comment.

① I certainly created an entity named "Month Stamp" in the regular entity, apart from the time entity.
②This is because I wanted to separate the month of the CSV file to be imported and the month to manage which month the imported data is from (for version control).
The image of the CSV to be imported is
"202403.csv"
Project name/sales month/sales amount

Project 1/202304/100
Project 2/202405/200
"202404.csv"
Project name/sales month/sales amount

Project 1/202304/100
Project 2/202406/250

MSugiyama

@Shisong

Thanks for your comment. I was only changing the yellow relationships in the tree and not doing anything with the pink relationships. When I reset the pink relationship using normalization, the settings were also reflected in the data view. I was able to solve the problem. Thanks so much.

Federica Antonelli

@MSugiyama for other tips about relationship and normalization you can also check these articles below

https://community.board.com/discussion/16322/relationship

https://community.board.com/discussion/16323/relationship-scanning-for-errors