Timeline in Excel 2013 for Date Dimension from AS

Question

Timeline in Excel 2013 for Date Dimension from AS

m.f.

SSC Veteran

Points: 202
More actions
April 26, 2016 at 3:29 am

#150978

Hello,
i would like to insert a timeline in my pivot table, that is build from dimensions and measures from my AS-Cube.
I get a messages, there is no field with a date-format. It is not possible to insert a timeline.
It is not possible to format the column with the Date-Attributs to the datatype date, they still remain as a string.
If i specify my attribut in the AS-Solution as date or use a NameColumn, which is format as date it also doesn't work.
Any idea?

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

PB_BI SSCoach Points: 17461 More actions · Answer 1

You need to set the Value column of your Date attribute to use a date column from your relational source - beware this could have consequenses. You also need to mark the temporal dimension as a Time dimension.

I'm on LinkedIn

m.f. SSC Veteran Points: 202 More actions · Answer 2

hello, thank you for the reply.

I have changed the ValueColumn to a Column from the DSV which is from datatype date.

The dimension-type is Time.

The KeyColumn is a Intenger, the NameColumn is none.

I have tried it with the types Regular and Date for Dimension-Attribut which use the Date DataFiled from the DS.

But I still can't use the timeline.

PB_BI SSCoach Points: 17461 More actions · Answer 3

m.f. (4/26/2016)
hello, thank you for the reply.
I have changed the ValueColumn to a Column from the DSV which is from datatype date.
The dimension-type is Time.
The KeyColumn is a Intenger, the NameColumn is none.
I have tried it with the types Regular and Date for Dimension-Attribut which use the Date DataFiled from the DS.
But I still can't use the timeline.

You say you changed the ValueColumn - does this mean it was something else before? Just changing the source column of the ValueColumn to something else is not enough - you need to change the value column data type to Date also (it won't change automatically). Sorry if that wasn't clear.

I'm on LinkedIn

m.f. SSC Veteran Points: 202 More actions · Answer 4

The ValueColumn was not set before.

The datatype of my [Column_A] in the tabular model is from type date.

The ValueColumn from my Dimensionattribut [DateTest] now references to this [Column_A] in the tabular model.

The Type of the Dimension Attribut [DateTest] is date.

But the Dimension Attribut [DateTest] in Excel is still a Text.

PB_BI SSCoach Points: 17461 More actions · Answer 5

m.f. (4/26/2016)
The ValueColumn was not set before.
The datatype of my [Column_A] in the tabular model is from type date.
The ValueColumn from my Dimensionattribut [DateTest] now references to this [Column_A] in the tabular model.
The Type of the Dimension Attribut [DateTest] is date.
But the Dimension Attribut [DateTest] in Excel is still a Text.

Forgive me but have you processed these changes?

Also, have you set the table you are using for this as a Date type table (I mentioned the Time type before, but I didn't realize you were talking about SSAS Tabular) - Table>Date>Mark as Date Table?

I'm on LinkedIn

m.f. SSC Veteran Points: 202 More actions · Answer 6

yes, changes have been deployed an processed.

At the Moment, it seems to me, that the KeyColumn also must be of the datatype date, like the ValueColumn.

After these changes it works.

But i want to leave my KeyColumn as an integer, if it is possible.

m.f. SSC Veteran Points: 202 More actions · Answer 7

m.f. (4/26/2016)
yes, changes have been deployed an processed.
At the Moment, it seems to me, that the KeyColumn also must be of the datatype date, like the ValueColumn.
After these changes it works.
But i want to leave my KeyColumn as an integer, if it is possible.

The Key can be of datatype integer, but the ValuColumn from the KeyAttribut must also be from a column with Datatype Date.

No it works!

Thx!