Creating Cube Generates "Cell type is string" error
Posted: Thu Sep 14, 2017 11:58 pm
Just started learning and am creating my first cube. When running my TI process to create the cube I'm getting a "Cell type is string" error on every row from by data source. I'm not sure what you will need to help, so forgive me if this is long.
My data source is from a SQL Server ODBC connection to a simple data warehouse that has 5 dimensions and one fact table. The fact table joins to each dimension using an "ID" column. The query looks as follows:
I've created Dimensions in TM1 related to each of the columns in my query above. These dimensions are based on the Dimension tables in my DW and used the 'Name' fields from each of those tables (e.g. VersionName, YearName, etc..) as the element.
Within the cube, the variables I selected were as follows:
vVersion - has 'Sting' variable type and 'Element" as content
vYear - has 'Sting' variable type and 'Element" as content
vPeriod - has 'Sting' variable type and 'Element" as content
vCenter - has 'Sting' variable type and 'Element" as content
vAccount - has 'Sting' variable type and 'Element" as content
vFinancialAmount - has 'Numeric' variable type and 'Data' as content
The Advance tab has this in the epilog:
That's it!
One other thing... I couldn't figure out how to actually create the measure, but I assumed that setting the 'vFinancialAmount' variable as 'Data' content did it automatically.
My data source is from a SQL Server ODBC connection to a simple data warehouse that has 5 dimensions and one fact table. The fact table joins to each dimension using an "ID" column. The query looks as follows:
Code: Select all
SELECT
VersionName, YearName, PeriodName, CenterName, AccountName, FinancialAmount
FROM
FactFinancial FT
INNER JOIN DimVersion D1 ON D1.VersionID = FT.VersionID
INNER JOIN DimYear D2 ON D2.YearID = FT.YearID
INNER JOIN DimPeriod D3 ON D3.PeriodID = FT.PeriodID
INNER JOIN DimCenter D4 ON D4.CenterID = FT.CenterID
INNER JOIN DimAccount D5 ON D5.AccountID = FT.AccountID
Within the cube, the variables I selected were as follows:
vVersion - has 'Sting' variable type and 'Element" as content
vYear - has 'Sting' variable type and 'Element" as content
vPeriod - has 'Sting' variable type and 'Element" as content
vCenter - has 'Sting' variable type and 'Element" as content
vAccount - has 'Sting' variable type and 'Element" as content
vFinancialAmount - has 'Numeric' variable type and 'Data' as content
The Advance tab has this in the epilog:
Code: Select all
#****Begin: Generated Statements***
CellPutN(FinancialAmount,'Sample Financials',vVersionName,vYearName,vPeriodName,vCenterName,vAccountName);
#****End: Generated Statements****
One other thing... I couldn't figure out how to actually create the measure, but I assumed that setting the 'vFinancialAmount' variable as 'Data' content did it automatically.