?
Solved

Measure Groups

Posted on 2011-09-19
2
Medium Priority
?
419 Views
Last Modified: 2013-11-10
Hi there, I'm trying to do some comparision from my cube to the current reporting system (SAP).

i'm  trying to get a count of a column for a measure group. the name of the column is Forwarded.

The value in the fact table is either 1 or 0. I only really care about the rows that have a value of 1. I can't see how to change this in the cube editor. i can see how to reformat the measure and all that. but i just want to make sure that i'm counting only the necesary rows. My values are coming ever so slightly different than what is in production, i wonder if this is the reason why, i nver explicitly tell the cube to filter out the 1's...
0
Comment
Question by:Auerelio Vasquez
[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 Comments
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 2000 total points
ID: 36565784
Hi,

If your values are either 1 or 0, then surely the SUM (default aggregation) of the measure will return the correct value.
If not, then do you have any traceaility between your production system and your cube environemnt? Are you sure you're importing all rows correctly?

Tim




p.s. zone should be changed to OLAP
0
 
LVL 1

Author Comment

by:Auerelio Vasquez
ID: 36568675
Thanks. I did see that in the measure properties. And we were using sum, i just was not sure how it was doing the proper summing of the columns. Very very new to olap.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

765 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