Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
For the Section access I use excel and then load it in to INLINE table.
Now my problem is regarding * .
When I use * for all values it doesn't work.
Please provide me alternate solution.
Regards,
Sundar
Loading an Excel into an INLINE table is pretty much impossible. I guess you mean something else.
Did you use the STAR IS *; statement?
What do you mean with '...I use * for all values...'? The *-mechanism in a Section Access table is limited to 'all values in the same column in that same table. Not all values you encounter in your data model.
Peter
Try Peter's suggestion with Star statment.
Else you need to define all the fields one by one if not Star statement
As said above '*' in section access means something like "all the values previously loaded in section access for this field". To use * like it was "all values" I first load the admin security with all values, after this all the fields has all values and '*' works as expected, in example:
Section application;
Data:
LOAD COUNTRY, Sales From...
Section access:
Access:
LOAD * INLINE [
ACCESS, NTNAME
ADMIN, ADMINISTRATOR
];
Join LOAD Distinct COUNTRY Resident Data;
Concatenate (Access) // From here you can add usual security and '*' in COUNTRY will load all loaded values.
...