SQL Server Analysis Services announcement
-
1 VotesMicrosoft TechNet Wiki Gurus Needed! Apply Within! No One Turned Away!
May is under way! And the Guru early birds are showing the way! Could this be the month that we see the best ever TechNet article in the ...Sticky | 1 Replies | 207 Views | Created by [Kamlesh Kumar] - Wednesday, May 03, 2017 12:43 AM | Last reply by [Kamlesh Kumar] - Tuesday, May 16, 2017 12:14 AM
-
0 Votes
SSAS no aggregations forces ugly report??
HI all, I have a measure that is of type no aggregations. I know you have to use key columns at lowest level to make it work, which it does. Problem is that my key columns are of ... -
0 Votes
Populate Relational Table With Data From Tabular Model
I've been tasked with populating a series of relational tables with data from an existing tabular model. There are around seven dimensions and one main fact table. Ideally, I just ...Proposed | 4 Replies | 103 Views | Created by ansonee - Thursday, May 25, 2017 3:58 PM | Last reply by willson yuan - 1 hour 1 minutes ago -
0 Votes
Best practice on updating data in 2016 tabular model standard edition.
Hi, I have a fact table with a few dimension in a data warehouse. Then I have a tabular model where I initially loaded the data from the data ...Unanswered | 3 Replies | 48 Views | Created by Igor Gelin - 10 hours 4 minutes ago | Last reply by willson yuan - 1 hour 29 minutes ago -
0 Votes
USERELATIONSHIP function cannot be used while querying table 'MyTable' because of the row level security defined on table 'UserSecurity'
I am using a Tabular Model and I have row level security define. One of my measure is using userelationship for an inactive relationship and that inactive relationship table has a an active ...Answered | 4 Replies | 773 Views | Created by Moyz Khan - Tuesday, March 10, 2015 9:44 PM | Last reply by erapade - 1 hour 32 minutes ago -
0 Votes
How to handle multiple fact tables with different granularity with unrelated dimension in SQL Server 2012.
Hi, I have two facts, Incident and Incident Task. These can't be merged because Incident task is assigned to different teams than Incident. Once incident can have multiple tasks. ...Unanswered | 3 Replies | 68 Views | Created by anupkrtiwary - Saturday, May 27, 2017 8:59 AM | Last reply by willson yuan - 1 hour 38 minutes ago -
0 Votes
Fiscal Period
In a Fiscal Year from 1 Apr to 31 Mar the following year, there are 13 or 14 fiscal periods. This fiscal period is not on the same date range each fiscal year. However I built this ...Unanswered | 2 Replies | 68 Views | Created by pmak - Friday, May 26, 2017 9:43 PM | Last reply by willson yuan - 1 hour 52 minutes ago -
0 Votes
How to use Sum in MDX to calculate a total of the number of action
I want to calculate a total of number of actions submited in one page and i'm using MDX to do that, Yet i didn't really understand the format of the MDX query and how can i use ...Proposed | 2 Replies | 72 Views | Created by SwanR - Friday, May 26, 2017 8:56 PM | Last reply by willson yuan - 3 hours 3 minutes ago -
0 Votes
Multidimensional processing fails on sort order for distinct count
Hello all I have exhausted my skills at Google and Bing so I'm hoping someone here will have seen this. I am attempting to build two measures for a distinct count ...Proposed | 2 Replies | 77 Views | Created by Mike_TheMountainMan - Friday, May 26, 2017 7:01 PM | Last reply by willson yuan - 3 hours 40 minutes ago -
0 Votes
Importing Excel fileo on sharepoint to SSAS tabular Model ?
HI , I am new to SSAS tabular model, I want to create a cube from three excel files which are on SharePoint and few table from SQL DWH, I can import tables from DWH but have no idea ...Unanswered | 1 Replies | 68 Views | Created by Kosambi2212 - Friday, May 26, 2017 9:19 PM | Last reply by willson yuan - 5 hours 41 minutes ago -
0 Votes
Linkmember with two Date Dimensions
I need to compute the aggregate of Opportunities Count that are active at a time (which is defined by period between start date and closing date) Not just for that period but for over ...Unanswered | 4 Replies | 95 Views | Created by jayasreet - Thursday, May 25, 2017 3:23 PM | Last reply by willson yuan - 5 hours 53 minutes ago -
0 Votes
Query with 2 date filters works with currentmember but not with prevmember
startdate AND currentdate <closingdate So I am trying to replace currentmember with prevmember and nextmember but it does not work as they only work on members and not ...Proposed | 7 Replies | 136 Views | Created by jayasreet - Tuesday, May 23, 2017 6:32 PM | Last reply by willson yuan - 5 hours 54 minutes ago -
0 Votes
SSAS Tabular 2016 Processing Specific Inserts and Deletes
We have an SSAS Tabular model. The source is Spark. We have code that performs special inserts and deletes of our Spark/Hive data source. We want those inserts and deletes ...Proposed | 2 Replies | 70 Views | Created by James H. Robinson - Friday, May 26, 2017 4:41 PM | Last reply by willson yuan - 5 hours 57 minutes ago -
0 Votes
alias name for Dimension property
Does anyone know how to set alias name for Dimension properties for example, look at the below query SELECT ...Unanswered | 2 Replies | 90 Views | Created by Uge1 - Friday, May 26, 2017 3:24 PM | Last reply by willson yuan - 6 hours 13 minutes ago -
0 Votes
Convert a query to a member
I have query like this: select [Measures].[Law Firm Count] on 0, non empty ([Law Firm].[Client ...Proposed | 13 Replies | 213 Views | Created by MDXLaotu - Friday, May 19, 2017 2:37 AM | Last reply by willson yuan - 7 hours 16 minutes ago -
0 Votes
How to select one parameter and get corresponding conditions
I have two questions about how to select one parameter and get corresponding conditions. Question 1: How to achieve if I select one parameter then will use certain conditions, ...Unanswered | 2 Replies | 66 Views | Created by MDXLaotu - Friday, May 26, 2017 2:52 PM | Last reply by willson yuan - 7 hours 21 minutes ago -
0 Votes
Microsoft Visual Studio localhost connection problem
Hi, I have problem to create project in MVS After creating dimension I am clicking process and receive message "project couldnt be deployed to the localhost ...Proposed | 4 Replies | 101 Views | Created by Grzegorz65 - Friday, May 26, 2017 1:10 PM | Last reply by willson yuan - 7 hours 29 minutes ago -
0 Votes
I get error when i try to deploy my cubes. Please help me as i am new
hey!!!! I tried to deploy my cubes but got these error on visual studio 2012. Please help me as i am new and i dont understand what to do. Errors are listed ...Unanswered | 4 Replies | 156 Views | Created by Nida Akram - Friday, May 26, 2017 12:17 PM | Last reply by willson yuan - 7 hours 34 minutes ago -
0 Votes
RLS doesn't work when item in Fact is not in the security table?!
Hi, I've a Question. I have to check it myself in a demo situation but I'll like your opinion about the following problem we have encountered during testing of the ...Unanswered | 1 Replies | 53 Views | Created by Hennie7863 - Friday, May 26, 2017 9:55 AM | Last reply by willson yuan - 7 hours 53 minutes ago -
0 Votes
Dynamic Banding with slicing capabilities
Good day Forum I am having an issue coming up with a solution for a request from my business. I am looking for a way to implement a dynamic banding solution that is capable of ...Proposed | 1 Replies | 63 Views | Created by Matt Karriker - Friday, May 26, 2017 3:37 PM | Last reply by RichardLees - 8 hours 6 minutes ago - Items 1 to 20 of 39646 Next ›
