SSAS Error in project role

Tobias Strobel 41 Reputation points
2022-03-29T11:11:30.97+00:00

Ahoi,

i have a problem with me SSAS project which i am not sure what the reason is.
Depending on which user accessing the file files it shows an error or not.
Here is a "side by side" comparison of the same settings/window/tab of same role in the same file.
SSAS Multidimension --> Role --> Dimension Data Tab

Error Text:

  • Error retrieving children: The '$Ergebnisbereich' object was not found. Paramter name: Index
  • The browser is disabled because custom MDX expressions defined in the advanced tab were not validated due to the following problem:
    --> Der $Ergebnisbereich-Cube ist nicht vorhanden. (The Cube does not exist)

187887-screenshot.jpg

Anyone knows how to solve this?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,256 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,576 Reputation points
    2022-03-30T01:49:40.777+00:00

    Hi @Tobias Strobel ,

    According to the error message, please try to process the related dimension see if it can be resolved.

    "Error retrieving children: The '$Ergebnisbereich' object was not found", basically means the related dimension has been updated but has not been processed.

    So please try to process the related dimension see if it can be resolved. If it still failed, then I would suggest to do processing full for the SSAS project.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.