SQL Server Analysis Services announcement
-
0 VotesOLAP Performance versus AWS Redshift
This is more of an answer looking for a question, but I am posting it as I imagine many cube developers would be interested. If there is a better place for this, let me know and I'll re/move ...Sticky | 1 Replies | 188 Views | Created by RichardLees - Monday, August 12, 2019 1:32 AM | Last reply by Marco Russo - Monday, August 12, 2019 7:46 AM
-
0 Votes
RLS in SSAS 2017 Tabular - Not ready for prime time?
We have a Tabular model that's complex but not big. Over 100 tables but less than a 10GB memory footprint. Fact tables and dimensional tables in a Kimball dimensional model. When accessing the model ... -
3 Votes
DAX: Last Non Empty per date (Most Current Inventory)
Here is a little context. I have product subcategory as row label. I have a daily snapshot of inventory and using count of inventory as the measure. The measure I want to be sure ...Proposed | 13 Replies | 10043 Views | Created by DataNerd - Tuesday, February 4, 2014 3:13 PM | Last reply by Stefan Z. _ - Saturday, August 17, 2019 1:23 PM -
0 Votes
Designing tables for a report, dimensional or OLTP model ?
Hi, I got a vague requirement from the client and wondering if I should design that in a Analysis Services. However, I'm new to the SSAS. So please advice if I ...Unanswered | 1 Replies | 99 Views | Created by guest369 - Friday, August 16, 2019 4:12 PM | Last reply by Olaf Helper - Saturday, August 17, 2019 5:51 AM -
1 Votes
SSAS or SSRS running query in parallel on UAT but in serial on Prod
I am not sure if this is an SSRS question or SSAS question. I have a report in SSRS with about 8 parameters that are tied to DAX queries that have as their main parameter the value of another ...Unanswered | 2 Replies | 109 Views | Created by Russ Loski - Thursday, August 15, 2019 8:57 PM | Last reply by Russ Loski - Friday, August 16, 2019 3:42 PM -
0 Votes
Project Burndown cont.
I previously asked this quesion which didnt quite solve my ...Unanswered | 2 Replies | 104 Views | Created by jshinnenkamp - Thursday, August 15, 2019 8:38 PM | Last reply by jshinnenkamp - Friday, August 16, 2019 12:17 PM -
0 Votes
MDX Cumulative Count - With Repeating Numbers?
Hi I am trying to build a cumulative count, however it is returning a value where it should not? In the screenshot below you will see that the 'green' cells are ...Unanswered | 9 Replies | 124 Views | Created by I.W Coetzer - Friday, August 16, 2019 6:21 AM | Last reply by I.W Coetzer - Friday, August 16, 2019 10:22 AM -
0 Votes
Can MDX be used for this?
Hi Team, I have not used MDX before and, although reasonably good with DAX, I am struggling with the syntax. My original request is ... -
1 Votes
Does row level security works if null value found in cube model ?
I have created one sales cube which has country wise sales table and country table and security group table like below. SALES ...Answered | 1 Replies | 70 Views | Created by Amira Bedhiafi - Friday, August 16, 2019 9:32 AM | Last reply by Will_Kong - Friday, August 16, 2019 9:48 AM -
0 Votes
MDX - How to SUM a calculated measure - only if value is greater than a given value say 1000
Hi I have a measure group with an [Amount] - currency measure. I want to create a calculated measure to SUM the [Amount] - but ONLY those ...Answered | 6 Replies | 128 Views | Created by I.W Coetzer - Thursday, August 15, 2019 3:33 PM | Last reply by Will_Kong - Friday, August 16, 2019 7:14 AM -
0 Votes
How to find the last processed datatime of SSAS cube?
Hi, I need to show the SSAS cube last processed datetime on SSRS report and I'm using below query to find the same but recently I've observed from my own testing that this gives you ...Answered | 4 Replies | 11669 Views | Created by Atul Sharan - Wednesday, April 17, 2013 1:33 PM | Last reply by S Kumar Dubey - Friday, August 16, 2019 6:51 AM -
0 Votes
Show One value in all the rows in a single column
Hi I have a data in following format in my tabular ...Unanswered | 3 Replies | 180 Views | Created by AlwaysLearner08 - Wednesday, August 14, 2019 10:25 PM | Last reply by Darren Gosbell - Friday, August 16, 2019 4:04 AM -
0 Votes
Conditional RLS - show everything when condition leads to blank or NULL
Hi, I have a RLS implemented based on line of business in my org. I have User table and Data table with LOB setup and joined properly. = Deals[Line Of ...Answered | 13 Replies | 385 Views | Created by manalla - Tuesday, August 6, 2019 7:23 PM | Last reply by Darren Gosbell - Friday, August 16, 2019 3:25 AM -
11 Votes
Unable to connect to a data source using excel 2013
We are trying to access a sql cube by creating a new connection using excel 2013. The error message received is "Unable to connect to data source.Unable to locate database ...Proposed | 15 Replies | 14513 Views | Created by mathurabhishek - Sunday, December 1, 2013 11:09 PM | Last reply by Rick Teixeira - Thursday, August 15, 2019 4:18 PM -
0 Votes
Testing calculated members in cube browser
Dear SQL, I am new to MDX and cubes as a whole so pardon my question. I am trying to add a distinctcount of orderid's so that I can see the orders per customer. ...Answered | 6 Replies | 146 Views | Created by Michiel- - Wednesday, August 14, 2019 3:20 PM | Last reply by Darren Gosbell - Thursday, August 15, 2019 12:36 PM -
0 Votes
Project Burndown help
I'm trying to make a burndown report and here is some sample data. I'm having trouble getting what I'm going for (I have a model in ssas, this is just data in pbi because it was ...Answered | 3 Replies | 244 Views | Created by jshinnenkamp - Tuesday, August 6, 2019 6:47 PM | Last reply by Will_Kong - Thursday, August 15, 2019 8:01 AM -
0 Votes
Attribute in first level in hierarchy is not visible in cube
Hi, I have added a new attribute to an existing dimension. That attribute is used in a hierarchy at level one and there is another attribute in hierarchy at level two. Source data ...Unanswered | 20 Replies | 368 Views | Created by taghalib - Thursday, August 8, 2019 6:23 AM | Last reply by Will_Kong - Thursday, August 15, 2019 7:04 AM -
1 Votes
SSAS Cube : De-duplication of facts
Hi, I have a question on offsetting some fact values from the cube based on business rules.. Scenario : I am getting sales figures for a ...Proposed | 5 Replies | 294 Views | Created by Ashu_Blueray - Wednesday, August 7, 2019 3:35 PM | Last reply by Will_Kong - Thursday, August 15, 2019 6:49 AM -
0 Votes
measure to calculate users who logged in from daily snapshot data
today()-7) Notused=DISTINCTCOUNT('Table'[Username])-[Measure] I tried the same logic in a measure within the fact table because i ...Answered | 3 Replies | 302 Views | Created by msdnpublic1234 - Saturday, August 10, 2019 4:06 AM | Last reply by Will_Kong - Thursday, August 15, 2019 5:54 AM -
17 Votes
The size specified for a binding was too small, resulting in one or more column values being truncated.
Hi All When processing the cubes i'm getting the following error The size specified for a binding was too small, resulting in one or more ...Answered | 12 Replies | 22826 Views | Created by saivenkat77 - Sunday, June 2, 2013 1:02 AM | Last reply by Harvin Toledo - Wednesday, August 14, 2019 11:41 PM -
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 | 2 Replies | 137 Views | Created by Priyadarshini Vaishampayan - Tuesday, August 13, 2019 1:21 PM | Last reply by Darren Gosbell - Wednesday, August 14, 2019 9:05 PM - Items 1 to 20 of 42520 Next ›
