This should be done with Section Access and using Enable Conditional for Dimension in each chart.
Please find attached file for solution.
Login with user ID :
A - Can see all the columns
B - Can see Sno column
C - Can see name column
D - Can see sno, name and dob columns
Try like this
LOAD * INLINE [
star is *;
B, 1, 0,0,0,0
Note: You need to select Document Properties -> Opening tab -> and select Initial Data Reduction based on Section Access option
Thank you, here you are using inline load in SECTION APPLICATION, normally when we load flat file , loading data from SAP-BW CUBES, in such cases we get file path LOAD [COLUMNS] FROM [TABLE NAME]
in this cases can we use the section access USER ID. in this . if we use it acts like new column. so how to use section access in this cases. The reason for asking this, in real time, we will have huge no. of rows, so we can enter it manually in INLINE LOAD. in SECTION APPLICATION. there is any solution for that.