Cube functionality different in Visual Studio vs Report Manger
Posted on 2008-06-12
I have a cube with 3 fact tables (Outpt Services, Hosp Services, Crisis Services) and several dimension tables. All 3 fact tables directly relate to each dimension table. When testing in Visual Studio, I am not limited in the number of fact measures that can be added. eg. I am able to develop a report with year on the top axis, provider on the left axis and the following measures - # of crisis episodes, # of hosp admissions, # of outpt services. When recreating in Report Manager, I seem to be limited to one fact table. Is this a limitation of Report Manager, or did I miss something in the development? I have checked the Dimension Usage tab for the cube. All items are represented on the grid. I am new to OLAP so any assistance / information would be greatly appreciated.