Solved

Measure Groups

Posted on 2011-09-19
2
412 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
Comment Utility
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
Comment Utility
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

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)

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

743 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

16 Experts available now in Live!

Get 1:1 Help Now