Solved

Measure Groups

Posted on 2011-09-19
2
413 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:basile
2 Comments
 
LVL 15

Accepted Solution

by:
Tim Humphries earned 500 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:basile
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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

911 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

Need Help in Real-Time?

Connect with top rated Experts

26 Experts available now in Live!

Get 1:1 Help Now