No announcements
Found 589771 threads
-
0 VotesSSAS Tabular - Excel filtering date
If a date field is in the Report Filter area, only the date check boxes are available.Answered | 2 Replies | 947 Views | Created by calimero48 - Saturday, September 29, 2018 6:45 PM | Last reply by calimero48 - Tuesday, October 2, 2018 8:22 AM
-
1 Votes
Filter Date Table (SSAS Tabular)
I had similar question sometime back, check if you find something useful from this thread -Answered | 2 Replies | 1403 Views | Created by sammydeprez - Monday, October 6, 2014 2:11 PM | Last reply by greggyb - Monday, October 6, 2014 3:53 PM -
8 Votes
SSAS Date Fields not working with Excel Date filters
Excel reports that we have been using fine for years against SSAS 2005 have stopped working against our new 2008 R2 server.Answered | 17 Replies | 24387 Views | Created by Sean Z - Wednesday, August 20, 2008 1:04 AM | Last reply by Shuvo27 - Tuesday, January 27, 2015 5:48 AM -
1 Votes
Wrong Date Format, SSAS Tabular and Excel
Second, you could add a numeric column to your data holding the date in Excel's format (43084 for for Dec 15, 2017 etc.).Answered | 8 Replies | 7094 Views | Created by TheBiConsultant - Thursday, December 14, 2017 1:17 PM | Last reply by John McP - Monday, January 15, 2018 2:40 PM -
9 Votes
Change Excel report from PowerPivot to SSAS Tabular
It moves the PowerPivot from the Excel report into an SSAS Tabular model, and updates the Excel report to point to this tabular model.Answered | 10 Replies | 1957 Views | Created by pmdci - Wednesday, August 17, 2016 1:19 PM | Last reply by pmdci - Sunday, October 30, 2016 10:37 AM -
0 Votes
SSAS Tabular Model in Excel issues
The SSAS server actually returns the metadata sorted alphabetically, it's not something Excel is doing, so the fields are already in "datasource order" and Excel ...Answered | 6 Replies | 3760 Views | Created by MurtzD - Wednesday, May 20, 2015 4:23 PM | Last reply by Darren Gosbell - Thursday, May 21, 2015 9:09 PM -
0 Votes
Excel and SSAS Tabular Data Model Data Types
https://bidshelper.codeplex.com/wikipage?Answered | 2 Replies | 3019 Views | Created by K. Beckett - Monday, June 10, 2013 3:54 PM | Last reply by K. Beckett - Tuesday, June 18, 2013 12:21 PM -
0 Votes
SSAS Tabular model
A major advantage of using SSAS tabular model instead of loading your company database or data warehouse into Excel is that you can store and share your ...Answered | 5 Replies | 1519 Views | Created by Albo44 - Thursday, January 5, 2017 11:45 PM | Last reply by Matt Allington - Friday, January 13, 2017 3:47 AM -
0 Votes
SSAS Tabular Model Performance
Immediately after cube processing or immediately after ClearCache does the report perform fast for a user without any role based security filters?Answered | 1 Replies | 1539 Views | Created by Rihan8585 - Friday, April 10, 2015 9:00 AM | Last reply by GregGalloway - Sunday, April 12, 2015 1:02 AM -
0 Votes
Filters in SSAS that do not flow into Excel
Hi Dave_C_Mke, Just add to Darren's reply, to filter those records in Excel, you can add report filter in Excel.Answered | 3 Replies | 923 Views | Created by Dave_C_Mke - Thursday, December 3, 2015 2:24 AM | Last reply by Simon_Hou - Tuesday, December 8, 2015 11:44 AM -
1 Votes
Date Format SSAS 2012 Tabular - Excel 2010
as you say that you have several entries date-entries per day you are not using a date-table - right?Answered | 1 Replies | 1923 Views | Created by MassimoMT - Friday, January 10, 2014 9:32 AM | Last reply by Gerhard Brueckl - Friday, January 10, 2014 9:52 AM -
0 Votes
SSAS Tabular - "built-in" ?
For some reason my tabular model dimensions do not have _Count measures.Answered | 3 Replies | 999 Views | Created by Sylvain06 - Friday, May 15, 2015 4:49 AM | Last reply by Darren Gosbell - Tuesday, May 19, 2015 4:59 AM -
1 Votes
SSAS Tabular Role
Hi Lukas, I asked the user to try, he was using Excel and Power BI desktop and he can see all the entities which I think it's weird because I added him to a Role.Answered | 4 Replies | 924 Views | Created by Gil Gerald - Tuesday, April 7, 2020 6:56 AM | Last reply by Gil Gerald - Friday, April 10, 2020 11:37 PM -
0 Votes
SSAS Tabular Translations don't appear on Excel
Answered | 2 Replies | 1544 Views | Created by Lrmmf_ - Monday, October 15, 2018 11:37 AM | Last reply by Dave Patrick - Tuesday, October 16, 2018 3:20 AM -
5 Votes
How to load SSAS tabular databse tables in to powerpivot
when i tried analyse in excel from SSAS tabular model, was not able to get the fields to create power view.Answered | 5 Replies | 1345 Views | Created by MSBIBeginner - Wednesday, August 19, 2015 12:09 PM | Last reply by Idr_p - Thursday, August 20, 2015 4:24 AM -
1 Votes
SSAS Tabular - Grouping in Excel - grayed out for Tabular?
You can't use Excel to do this, but you can build this sort of functionality into your model using techniques list ...Answered | 6 Replies | 2861 Views | Created by OneWithQuestions - Tuesday, November 10, 2015 2:19 PM | Last reply by Darren Gosbell - Tuesday, November 10, 2015 10:39 PM -
0 Votes
SSAS Tabular small database fails in Excel pivottable because of memory shortage?!
DISTINCTCOUNT inside CALCULATE filtered against a table...Answered | 10 Replies | 2081 Views | Created by Pedro Samuel - Thursday, May 7, 2015 4:40 PM | Last reply by OneWithQuestions - Monday, August 10, 2015 8:20 PM -
0 Votes
Connect to SSAS tabular model hosted on azure VM via excel powerview
This link explicitly mentions connecting excel 2013 to a tabular model in ...Answered | 4 Replies | 2709 Views | Created by icon1234 - Tuesday, March 4, 2014 4:14 AM | Last reply by Charlie Liao - Wednesday, March 5, 2014 6:52 AM -
0 Votes
SSAS Tabular downgrade compatibility
These features include bi-directional filtering, calculated tables, native translations and display folders, better and less glitchy IDE, the new TMSL json-based scripting language, the TOM ...Answered | 4 Replies | 2085 Views | Created by Mukul pratap sengar - Wednesday, August 29, 2018 11:27 AM | Last reply by willson yuan - Thursday, August 30, 2018 6:04 AM -
0 Votes
Tabular w/Excel: How to filter a measure where NOT blank in PivotTable?
So to clarify, even though I have a Collected Date column, there is no way to filter on that = blank, because those values will be filtered out ...Answered | 3 Replies | 2847 Views | Created by OneWithQuestions - Monday, November 23, 2015 5:18 PM | Last reply by Darren Gosbell - Monday, November 23, 2015 9:36 PM - Items 1 to 20 of 589771 Next ›
No announcements
