This does not seem normal. The expected behavior in this scenario would be retrieving the data from the original source when a warehoused cube is checked out to you.
Also, for your information, check-in/ check-out status is individual to the user. If a user checks out the cube, only for that user the cube is checked out and data is retrieved from the original data source, however, the other users will still see a result that is retrieved from the warehouse database. Warehouse data is retrieved if the storage type is “Warehoused” AND the cube is in check-in status for that user.
So, it should not throw that error message when you have checked out your cubes. I tried to reproduce this issue, but everything was working fine and once the cube was checked out, I could still see the result in dashboards.
To better troubleshoot this issue, I’d suggest communicating through emails and I’d appreciate if you could clarify the following in your email:
- The exact version of your Dundas BI,
- Complete error message with stack trace,
- Other errors if there is anything related in Admin -> Logs
- If this issue happens globally for any cube or any user or just for some specific cases