Pages drop down menu show extra values

Questions & Answers
1

I put one of my dimensions (month list) into Pages to use in the drop-down menu to see specific month’s stats. But it shows additional options in it.
In fact, in previous cubes I had names of 12 months but I wanted to change their name to number of month. So I changed it in the postgresql query. Now in the new cube, I see 12 month number in addition to previous 12 month name.

Previous month list in the Pages drop down menu: Jan, Feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec
Now in drop down menu I see: 1,2,3,4,5,6,7,8,9,10,11,12,Jan, Feb, Mar, Apr, May, June, July, Aug, Sept, Oct, Nov, Dec
I think every time I change that column all previous values of that column still shows in the drop down menu.

but I expect to see new values(month number) and not old values(month name). what is the problem? Is it related to cache or something?

2

Hi @MikeW,

When making changes to the data mapping, we recommend deleting the previously imported data. Please refer to the eazyBI documentation page for more details - Data mapping.

Best,
Roberts // support@eazybi.com

1 Like
3

Thank you for your answer.
I still do not get it. I have many plots and reports in many cubes and all this link you sent says I need to delete one of them, but I will lose all the reports and plots. How can I solve the problem?
Can I export all reports from all cubes, delete all cubes, and then create them again? Does this solve my problem?

4

Hi @MikeW,

From your description, it seems only one dimension is affected - “Month list”. In how many cubes is this dimension referenced and in how many does it return the undesired values?

The documentation page recommends deleting that particular dimension only. Once you have deleted it, you can run the data import and re-create the dimension with the actual members.

Kind regards,
Roberts // support@eazybi.com

5

Thank you for your response.

Yes, it’s only one dimension, and I believe it is referenced in most, if not all, of the cubes. It contains 24 values for months, which are duplicated. Each cube has multiple reports, and many of them are also used in dashboards.

If I need to delete that dimension from all cubes and then re-import it, won’t that cause issues with the dashboards and reports?

For example, I created a simple cube that includes the problematic “month” dimension and another column, and then created some reports. After deleting the dimension (following the documentation) and re-importing the data, I tried to open those reports again — but I got this error:

“Report definition contains page dimension ‘month’ which is not present in the cube.”

It seems I can’t add the “month” dimension back to those reports, which makes the entire cube unusable.

So, if I follow your suggested solution, I fear I’ll lose all my cubes, reports, and dashboards — and I really don’t want to recreate them. I have nearly 50 cubes with over 100 reports across multiple dashboards.

6

Can I find where it is stored in the back end and in the OS and deleting it?

7

@roberts.cacus
Do you have any Idea?

8

Hi @MikeW,

You reference multiple cubes. Are all of these cubes in the same eazyBI account? In that case, the dimensions with the same name are shared across cubes in the same eazyBI account and will have shared members.

Review all cube sources and see which one of them still has the data import for the dimension “Month” with the original numeric values. In my testing, with source file import in eazyBI 8.0.2, uploading a new file with numeric values replaced by month names, removed the numeric value members from the dimension.

Kind regards,
Roberts // support@eazybi.com

1 Like