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
36 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
ID: 40510200
I fixed this by changing the data type in the ribbon.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Add a step to a system backup job 6 18
SQL Activity Monitor detail 2 24
SQL Quer 4 21
.NET Enums [Flags] & Bitwise Design Question 6 24
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…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
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.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

840 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