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

x
?
Solved

Measure Groups

Posted on 2011-09-19
2
Medium Priority
?
421 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

Tech or Treat! - Giveaway

Submit an article about your scariest tech experience—and the solution—and you’ll be automatically entered to win one of 4 fantastic tech gadgets.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
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.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

604 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