We have run into troubles after changing few options in Select List (Single Choice) custom fields. New values was not covered in reports after scheduled cube update. I had to empty the cube and build it again manually.
- Is it possible to improve import so it would check for this automatically? Or maybe add some option for full cube update. For example we would daily incremental updates and full update on Saturday night.
Few hours later several users reported problems with reports. They started to time out, event if they was fast previously. It took me some time to realize that it is because of changed options of Customfield mentioned above. It was used in Pages to filter results. I had to remove it, save the report, add it, pick new value and save the report. It appears that those things are handled by value and not by ID of the option.
- I guess that change EazyBI to handle it by ID would be too difficult, but it would be great if we could at least mitigate the issue. Instead of timeout, there could be an error that some dimension have invalid option picked. In fact, it could be just warning and report could proceed ignoring such selection - it may take some time before report owner will get there, so report viewers can see at least something in the meantime.
Thank you for your consideration