4/17/2023 0 Comments No scroll bar in excel timelineOpen your Multidimensional solution in SQL Server Data Tools (SSDT) The following is what you will have to do to fix the error when PivotTable is sourcing data from Multidimensional Cubes: Resolving Timeline Filter error when using Multidimensional Cubesįixing the Timeline error involves several steps. The reason for this error is because the Timeline filter is unable to detect any dimensions containing dates field in your PivotTable. If you have not properly configured your OLAP solution, then you are likely to run into error message “ We can’t create a Timeline for this report because it doesn’t have a field formatted as Date”, similar to what is shown in Figure 3. Multidimensional cubes, Tabular Model, and PowerPivot excel workbooks). This is in stark contrast to the traditional filter shown in line 1 of Figure 2 wherein it only indicates that multiple items have been chosen and the only way to understand on what those filter items are, is by clicking on the dropdown button.Īlthough the Timeline feature is a great control, getting it to work and correctly pick out date defined fields can be a frustrating task, particularly if your PivotTable is sourcing date from any of the SQL Server OLAP solutions (i.e. It also has useful annotations that describes what you have filtered on – in this case, we have chosen sales period between February and March 2011. Figure 1 illustrates one of those benefits whereby the Timeline filter allows end-users to easily apply a filter (i.e. The Timeline filter has several benefits compared to the traditional Excel dropdown filter. The Timeline filter control enables end users to visually filter Excel PivotTables using fields defined as dates. One such feature is the Timeline filter control which was first introduced in Microsoft Office 2013. Like many software products, newer version releases of Excel usually introduce new features. One of those data visualisation tools, is Microsoft Excel – which remains a popular data visualisations tool for many of my end users. These solutions have been consumed using numerous data visualisation tools. Over the course of my career, I have developed and deployed to production several business intelligence solutions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |