Share via

how to change ALL description in SSRS paramter

Radi Soufan 6 Reputation points
2021-06-17T09:37:58.737+00:00

Hello...
I have an SSRS project that is connected to an analysis services solution...
the parameter contains values of a dimension one value is a build-in value which is
ALL..
is there a way to change the description of that value to ALL VALUES.. or any other description??
thank you

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,912 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Lukas Yu -MSFT 5,821 Reputation points
    2021-06-18T06:33:40.81+00:00

    Hi,

    I guess you are connecting to multidimensional cube in SSAS, right?

    If you want to change the displaying name of AllMember, you need to edit the cube. In that dimension edit windows, choose the hiearchy you are working right click for its property, then you can see the property AllMemberName, you could change the display name there.
    106850-image.png

    Regards,
    Lukas

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.