Error messages in layouts more explicit than "Oops"

Etienne CAUSSE

Hi all,

Context & issue:

A few months ago, we implemented a limit on reports known as "Rows Upper Limit" to prevent users from overloading the system with too big queries (usually, addind all axis of a cube to extract everything to excel...).

Due to this limit, sometimes the users have a "Oops" error in their layout, but no indication about the reason.

 

Idea : implement specific error messages for the users, such as

- "Error : your query has a potential number of results exceeding 2 millions [insert dynamically the Rows Upper Limit value]"

- "Error : your query cannot be executed due to unavailable dimension in cube XXX"

 

You see my point  This would be very helpful to propagate the use of Layout editor (or Quick Layout as Pietro Ferrari mentioned, event if less risky if I understand).

Etienne

Monisha Jain

Hi Etienne, thank you for sharing your idea! We appreciate the time and effort you put into crafting your suggestion.

Great news, in the Summer 2022 release, a new parameter to set the limit is explained here:

https://community.board.com/discussion/15234/how-to-manage-and-prevent-runaway-queries

In addition to that we have introduced the new Diagnostic log verbosity level in the latest Spring 2023 release: https://www.boardmanual.com/2021/summer/whats-new-release-notes/2023-spring-release/other-enhancements.htm