Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am facing one issue with the section access is, I am having one qvw file where section access works on the particular field and now I have added one new table which which don't have that field and that new table is linked to existing data model and now when i open the dashboard it wont show me any data for the report which I have developed on newly added table.
So, now I want to bypass section access on the newly created table how to handle please suggest!
Section Access is an all-or-nothing affair. If you want to bring new data into a data model that is being reduced based on some linked section access value, and you want to include all of this table, you have to add a dummy connection that links to all of the rows in this new table at all times.
For example, add a field to your new table called DUMMYLINKFIELD and put a value of 'ALL' in every single cell of this field.
Then in all your Section Access rows, add a DUMMYLINKFIELD column with value 'ALL'. Reload.
Hi Peter,
Thanks for your reply.I have tried ALL with dummy field but seems not working.Any other solution?
Would you mind sharing your code.
What level of section access you have and is the new table linked with old table with any field? Try making it island if that is the case. You can rename column or simply can use Qualify Statement.