The issue was resolved by closing the connected Excel file, creating a new Excel workbook, connecting to the cube, and only then trying to create the offline cube. Thanks.

FK: Triggers are somewhat evil by nature (sorry for strong words). Your modify_user is set by your application, not by user input. Hopefully, you are using stored procedures. Then...

I'll try to be brief.

Don't think of it as "90 tables per tenant'. Think "one schema per tenant". All tenants have SAME schema. Their data sets do not intersect in...

The solution depends on the details of your business requirements. If the number of tenants is not large, one path is to create a new schema for each new tenant....