SQL Server Analysis Services announcement
Found 43219 threads
-
0 VotesCalculated Mmber Aggregate Wildcard issues
= 1) --WILDCARD + FILTER([Date Dimension].[Date SOP Month].Members,Instr([Date Dimension].[Date SOP Month].CurrentMember.Name,"M2",1) >= 1) + FILTER([Date ...Answered | 10 Replies | 5270 Views | Created by Ismailc1 - Monday, June 8, 2020 2:07 AM | Last reply by Ismailc1 - Sunday, August 30, 2020 8:52 PM
-
0 Votes
Create multiple sets and union them in MDX
I need to create 2 sets. first set for DD cards which should be affected by DD Date only. and Set2 is Cash load cards which should only affected by Cash loads date. then, union of both sets. ...Answered | 8 Replies | 4731 Views | Created by Prajwal Potula - Friday, August 14, 2020 6:40 PM | Last reply by Darren Gosbell - Tuesday, August 25, 2020 1:56 AM -
0 Votes
How to supress rows with 0 values. All measures, fact and calculated, are 0
The cube going into browser or Excel, shows the ...Answered | 5 Replies | 9125 Views | Created by Maria Luz MUNOZ - Thursday, July 2, 2015 11:46 PM | Last reply by issue while adding report server extension vs2019 - Monday, August 24, 2020 12:29 PM -
0 Votes
SSAS MDX query
Hi Everyone, I have following query regarding mdx, My Dimension having structure and data ...Unanswered | 3 Replies | 4007 Views | Created by Vidya mane - Monday, February 16, 2015 11:06 AM | Last reply by issue while adding report server extension vs2019 - Monday, August 24, 2020 12:01 PM -
0 Votes
Complex Filter In Measure
I apoogize in advance if this post is somewhat pedestrian, but I'm fairly new to DAX, so I can use all the help I can get! I currenty have a measure which uses ...Answered | 9 Replies | 4580 Views | Created by ansonee - Sunday, August 9, 2020 2:32 AM | Last reply by ansonee - Monday, August 24, 2020 1:01 AM -
0 Votes
unable to connect through direct query mode?
I have two questions. 1.When i am trying to change my ssas tabular model with direct query mode its not working.Its throwing an error like this? Failed to ...Proposed | 7 Replies | 6072 Views | Created by Avinash93 - Friday, July 7, 2017 5:26 PM | Last reply by Ajit007 - Friday, August 21, 2020 12:29 PM -
0 Votes
dimension security on a dependent dimension
We have an existing secured dimension called scenario. Now we want to add security to another dimension called compensation but compensation is dependent on ...Unanswered | 8 Replies | 3694 Views | Created by sudi107 - Monday, August 10, 2020 11:29 AM | Last reply by Laxmidhar sahoo - Friday, August 21, 2020 9:10 AM -
0 Votes
Organizing measures in a separate table in SSAS tabular cube
Hello I have lots of calculated measures scattered across two tables and want to organize them. How can I create a "dummy" calculated table so that all measures can be ...Answered | 3 Replies | 4516 Views | Created by Priyadarshini Vaishampayan - Tuesday, August 13, 2019 1:21 PM | Last reply by RichardHardy - Friday, August 21, 2020 8:54 AM -
1 Votes
SSAS Tabular performance issue with Powerbi
Hello community, My company has just stopped supporting our Cube and we are moving to tabular/Powerbi. I have picked up a relatively small tabular model and i need to Port some MDX ...Unanswered | 3 Replies | 3639 Views | Created by BLDataCrank - Friday, January 24, 2020 4:28 AM | Last reply by Marco Russo - SQLBI - Thursday, August 20, 2020 9:01 AM -
0 Votes
SSAS Tabular: Query Timeout during Preview, Despite Timeout =0
I am using SSAS Tabular in Visual Studio 2017 against a SQL Server instance (Compatibility 1200) I have a relatively small query (Unanswered | 2 Replies | 4031 Views | Created by BrainE - Friday, August 14, 2020 5:25 PM | Last reply by Darren Gosbell - Thursday, August 20, 2020 3:51 AM -
0 Votes
The connection either timed out or was lost- SSAS Error while cube synchronization from source server to destination
Hi, I am executing XMLA script via scheduled SSIS dtsx package to synchronize the ssas cube form source to destination server. Everytime it works fine but ...Proposed | 5 Replies | 5151 Views | Created by ScriptSoft - Tuesday, August 4, 2020 10:06 AM | Last reply by Lukas DreiKlein - Wednesday, August 19, 2020 5:28 AM -
0 Votes
what to setup in SQL profiler to investigate SSAS Cube synchronization job hang?
Hi, I am using SSIS job to process the ssas DB(cube, dim, partition etc) in source server and XMLA script in the same SSIS package to synchronize the SSAS DB from source server to ...Proposed | 3 Replies | 4643 Views | Created by ScriptSoft - Thursday, August 6, 2020 3:02 AM | Last reply by Lukas DreiKlein - Wednesday, August 19, 2020 5:28 AM -
0 Votes
Display Zero in the empty Rows MDX
HI All, I was writing one MDX code so I wanna display "0" for empty rows. I was calling two rows in some cases it might have empty rows in some cases. ...Answered | 2 Replies | 4537 Views | Created by BandSr - Thursday, February 28, 2013 9:50 AM | Last reply by issue while adding report server extension vs2019 - Tuesday, August 18, 2020 3:13 PM -
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 ...Answered | 5 Replies | 9949 Views | Created by Nida Akram - Friday, May 26, 2017 12:17 PM | Last reply by RNaray - Tuesday, August 18, 2020 1:59 PM -
0 Votes
performance issue
Hi, I have the following measure(Actual) which when sliced by fields from Employee dim consumes lot of memory and visual takes a lot of time to load.How can i optimize ...Proposed | 5 Replies | 4124 Views | Created by msdnpublic1234 - Thursday, August 6, 2020 1:21 PM | Last reply by Lukas DreiKlein - Tuesday, August 18, 2020 6:59 AM -
0 Votes
Create a set which is not effected by where clause in MDX.
By using below query, I want to get card IDs for DDDate in where clause but, Cash Loads date should NOT affect the set. But its not working. set is filtered by both dates in where clause. Please let ...Proposed | 5 Replies | 4138 Views | Created by Prajwal Potula - Thursday, August 6, 2020 2:41 PM | Last reply by Lukas DreiKlein - Monday, August 17, 2020 6:42 AM -
0 Votes
reporting using Jasper Studio
Hello Im trying to build a report using jasper studio for reporting connected to SSAS tabular cube... it was not that easy.. specially with the configuration... ...Unanswered | 2 Replies | 2845 Views | Created by radissoufan - Sunday, August 16, 2020 7:06 AM | Last reply by Lukas DreiKlein - Monday, August 17, 2020 6:37 AM -
0 Votes
DAX issue. Fact table with missing dimension attributes members
I have a fact table has a sales measure with accounts, numbered 1 though 100 for example. My dimension table only has accounts 20 through ...Unanswered | 1 Replies | 3403 Views | Created by Computermike - Friday, August 14, 2020 12:56 PM | Last reply by Lukas DreiKlein - Monday, August 17, 2020 1:41 AM -
1 Votes
Power Bi not accepting values from SSAS columns
Hi, I have just started dealing with SSAS. I am used to model and report directly in Power Bi but recently I had to start creating models in ...Answered | 2 Replies | 4319 Views | Created by Rafael_H - Monday, August 10, 2020 4:29 PM | Last reply by Rafael_H - Sunday, August 16, 2020 3:49 PM -
0 Votes
display local cost from USD for budget data
1..MUSage to lookup->M..1Lookup to Budget->1..M The real dataset contains ~6000 users and 10 more products.There is another table for currency conversion that states local ...Unanswered | 4 Replies | 4459 Views | Created by msdnpublic1234 - Wednesday, August 5, 2020 2:09 PM | Last reply by Lukas DreiKlein - Friday, August 14, 2020 5:35 AM - Items 1 to 20 of 43219 Next ›
