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
44 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: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
1 Comment
 
LVL 1

Accepted Solution

by:
Auerelio Vasquez earned 0 total points
ID: 40510200
I fixed this by changing the data type in the ribbon.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
index related performance counter  for SQL server DB 11 40
store vs query adhoc - no show rows 4 37
database audit for object access 6 42
T-SQL Query 9 37
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
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.
Viewers will learn how the fundamental information of how to create a table.

751 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