Solved

Measure Groups

Posted on 2011-09-19
2
415 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

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…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

856 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