Background: I have a industry specific database program that is used by a contractor for RMS. It has a really bad reporting function that does not provide the info that I require. It also has a data warehouse that provides CUBE data connections for Excel. While this provides more info, I need to take the DW’s output and connect it to other data sources for my reporting needs.
Question: Is it possible to take a live CUBE connection in Excel and add it to the data model to then create relationships?
