Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Cube functionality different in Visual Studio vs Report Manger

Posted on 2008-06-12
4
Medium Priority
?
446 Views
Last Modified: 2016-02-13
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.
0
Comment
Question by:jstackpole
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 8

Expert Comment

by:srnar
ID: 21777095
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?
0
 

Author Comment

by:jstackpole
ID: 21778163
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.
0
 
LVL 8

Accepted Solution

by:
srnar earned 1500 total points
ID: 21786368
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

609 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question