Hey, all. Probably a long shot, but thought I’d run it past you. In our environment, we do a nightly data cube build/rebuild. These cubes are our Oracle db tables. When we want to create a dataset with joins, we use these cubes and join them to make new cubes which are then the basis for metric sets, etc. Well, today I ran into a problem with a cube I’m trying to make. In one cube/table I have VENDOR_ID and SECOND_VENDOR_ID. This is supposed to join to another reference cube that has the vendor names in it. I joined it up to VENDOR_ID no problem, but when I went to add the cube again to join to SECOND_VENDOR_ID, Dundas tells me the cube already exists and that I can’t add it a second time.
Is there any way around this? If not, I’m guessing I’ll just have to add an overnight cube build which is just basically a copy of the first cube with a different name.
Appreciate any suggestions!