SolvedPrivate

Power Pivot thinks data type is String, however, the type is numeric/decimal from the source data to the cube. i

Posted on 2014-12-19
1
29 Views
Last Modified: 2016-02-18
I keep getting  this error when i try to change the measure on one of the fields, i know that my fields are numeric, but when i try to us the column as SUM i get this error:

ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (5, 74) The function SUM takes an argument that evaluates to numbers or dates and cannot work with values of type String. i've checked the data type in the sql database, and in the cube, and both are numeric......
0
Comment
Question by:basile
1 Comment
 
LVL 1

Accepted Solution

by:
basile earned 0 total points
Comment Utility
I fixed this by changing the data type in the ribbon.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

11 Experts available now in Live!

Get 1:1 Help Now