Recently upgraded from 5.1 to 7.0 and the data in my WB table appears to be excluded from the cube. When I pull an EVDRE report, the amounts that are in the WB table do not show up. When I process the cube in SSAS, it says that the WB table is processed, but it does not process any rows, there are rows of data in the WB table, and does not take any time. When I did a lite optimization, the data did show up in the EVDRE. So it is including the FAC2 and FACT data, just not the WB data.
I also tried an MDX query and it does not see the WB data either.
Thanks,
Blake