Cube functionality different in Visual Studio vs Report Manger

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.

On our projects are clients usually use static reports (via table object) or ProClarity - there is a ProClarity web version called PAS. For matrix reports I can recommend you not so expensive tool (Visual

Of course there is no limitation to count of measure group (fact tables) in reporting services. Which reporting object are you using (report layout)? Table or matrix? Can you post MDX that is producing the dataset?

In Report Builder I used a matrix layout. This is where it limits to one measure group. Our end users only have access to this tool. When testing I used the browser tab of the cube when developing in Development Studio. There were no issues in adding items from all measure groups.

On our projects are clients usually use static reports (via table object) or ProClarity - there is a ProClarity web version called PAS. For matrix reports I can recommend you not so expensive tool (Visual Studio add-in) called InteligenciaQuery - see http://www.it-workplace.co.uk/IQ.aspx. Server version is about 500 EUR.

0

Featured Post

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library. Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…

Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…