User Profile
RobiFitz2
Frequent Visitor
Joined 3 years ago
User Widgets
Contributions
Question on Multiple Golden Datasets with RLS
My company has multiple large servers pulling in a large sum of data for almost a hundred reports for our vendors. Currently each report has its own dataset pulling in some form of data that is similar to the next dataset however the query is fine turned towards that report and every report has RLS for each vendor.Everytime a new person is needed to be added to the vendor, we have to go through each dataset and add them to RLS. My question is, is it possible to have 5 golden datasets(1 for each server), then connect them in the report and setup RLS on 1 of them to only display data related to that vendor? I thought about 1 golden dataset however It is an extremely large amount of data with fear of the queries timing outUpdate excel cell based on condition of another sheet
I have 2 excel sheets in the same workbook; a live edited sheet and a master sheet. I am looking to update comment history by comparing the live and master file and if they do not match, concatinate together and replace the master comment. Right now I manually have to concatinate in excel then copy and paste to replace the comments for 24,000 rows. Note: I did try a macro however this is stored on and edited on a sharepoint which does not allow macros unless the file is downloaded Live file Invoice # Comment Date Comment Name Reason 100525 3/30/2023 Email update from Jim Sarah Billing date moved 100526 2/24/2023 Increase in budget needed Jim Waiting on increase Master File Invoice # Comment Date Comment Name Reason 100525 2/25/2023 Increase in budget needed Sarah Waiting on increase 100526 2/24/2023 Increase in budget needed Jim Waiting on increase Master File - result Invoice # Comment Date Comment Name Reason 100525 3/30/2023 [Name] on [Comment Date]; [live comment]; [Live reason] [master comment] Sarah Billing date moved 100526 2/24/2023 Increase in budget needed Jim Waiting on increase
