SQL Server Analysis Services announcement
-
0 VotesOLTP and OLAP databases on same SQL Server?
Would you put OLTP and OLAP databases on same SQL Server or separate? I realize the ideal would be separate, but that means 2 expensive licenses instead of 1. ...Answered | 1 Replies | 35 Views | Created by fiverc - 5 hours 48 minutes ago | Last reply by Vaibhav Chaudhari - 5 hours 16 minutes ago
-
0 Votes
Keeping versions of cube data
What's the best way to keep cube versions of the data, say we want to keep the version every quarter? So we could know what the cube would have shown us on the day we kept ...Unanswered | 2 Replies | 64 Views | Created by namnami - Thursday, February 26, 2015 11:05 AM | Last reply by Simon_Hou - 5 hours 39 minutes ago -
0 Votes
Use selected parameter in MDX WHERE slicer
I have an MDX query which slices data by Site Key: In a SSRS report, I have created a new Parameter of type integer named SiteKey with a default value of 1. I ...Unanswered | 2 Replies | 80 Views | Created by DarrenOD - Wednesday, February 25, 2015 1:29 PM | Last reply by Simon_Hou - 7 hours 0 minutes ago -
0 Votes
Authentication option is faded while connecting to analysis server.
Hi All, I have installed sql server 2012 enterprise edition in my system. I am able to work on it. But, today I got a work to connect with Analysis service. I want to connect ...Proposed | 2 Replies | 56 Views | Created by Julie Eliza Sam - Thursday, February 26, 2015 6:40 AM | Last reply by Simon_Hou - 8 hours 19 minutes ago -
0 Votes
filtering using strtoset
Hi, i have the following MDX query that uses parameters from an SSRS report to produce a result set: WITH MEMBER PREM ... -
0 Votes
How to stop a long running query in the cube browser without stopping BIDS?
Say youve dragged a dimension over into the rows and its churning away. Is there a way to recover gracefully without waiting forever? Only thing Ive managed to do to overcome this is ... -
0 Votes
SSAS 2008 Sample project - which measure groups/dimensions do I use in the cube browser to drilldown to order number
Im using the SSAS 2008 Sample project located here http://msftdbprodsamples.codeplex.com/releases/view/88252 Ive got everything setup finally, and working. ... -
0 Votes
SSAS 2008 R2 sample project errors during processing
Parser: The query contains the Associated_Measure_Group parameter, which is not declared. Got the sample project from here (Standard ...Unanswered | 1 Replies | 33 Views | Created by shiftbit - Friday, February 27, 2015 3:51 PM | Last reply by shiftbit - Friday, February 27, 2015 3:56 PM -
0 Votes
What is the difference between SSAS & Data Mart? Is SSAS required to create BI Dashboard in SharePoint 2013?
Hello All, Greetings for the day.! What is the main feature wise difference between SQL Server Analysis Service & Data Mart? Can we create BI Dashboard in ...Unanswered | 1 Replies | 48 Views | Created by jdoshi65 - Friday, February 27, 2015 10:23 AM | Last reply by Pau Sempere - Friday, February 27, 2015 3:39 PM -
0 Votes
SQL08 Need example of creating AND using a Fact (degenerate) dimension
Order Detail type scenario, with the addition of Orders have some additional attributes. So I want to be able to measure on for example: Order counts - broken ... -
0 Votes
Errors in the high-level relational engine. The data source view does not contain a definition for the table or view. The Source property may not have been set.
Hi All, I have a cube in which i'm using the TIME DIM that i created in the warehouse. But now i wanted a new measure in the cube which is Average over time and when i wanted to ...Unanswered | 2 Replies | 58 Views | Created by PMunshi - Thursday, February 26, 2015 11:52 PM | Last reply by PMunshi - Friday, February 27, 2015 2:22 PM -
0 Votes
"Totals calculation issue" when I filter member used in an scope calculation with descendant aggregation
State -> City) and 2 related Fact Tables: "Revenues" (with measure Revenue) and "Revenue Goal" (with measure Revenue Goal) and created a dummy measure into the ...Answered | 2 Replies | 76 Views | Created by dimitrigel - Wednesday, February 25, 2015 7:08 PM | Last reply by dimitrigel - Friday, February 27, 2015 1:06 PM -
0 Votes
Connection problems to Analysis Services (local)
netstat /abo | findstr 238 TCP 0.0.0.0:2382 ServerName:0 LISTENING ...Unanswered | 1 Replies | 40 Views | Created by Estre9 - Friday, February 27, 2015 12:02 PM | Last reply by Olaf Helper - Friday, February 27, 2015 12:17 PM -
0 Votes
Browse cube - Change User: The following system error occurred: The user name or password is incorrect.
Environment: Windows Server 2012, SSAS 2012 (11.0.5058) I have two identical SSAS Servers in the same domain. The SSAS project on machine B is a copy from machine ... -
0 Votes
SSAS Cube Total Amount showing correctly but monthly split up is wrong
Dear All, I have created two dimensions "Detail Fields" and "Time Period" from named query.Report Amount is the measure ...Unanswered | 1 Replies | 338 Views | Created by sankeats - Wednesday, July 16, 2014 8:56 PM | Last reply by sankeats - Friday, February 27, 2015 9:17 AM -
0 Votes
MDX YTD until previous month - problem for january
Hello, I have a Time hierarchy YQMD I want to make an MDX calculation that gives me the YTD until the previous month. I did this ...Unanswered | 3 Replies | 115 Views | Created by Sylvie Goetgeluk - Wednesday, February 11, 2015 9:19 AM | Last reply by Simon_Hou - Friday, February 27, 2015 7:43 AM -
0 Votes
Time Intelligence DAX functions are not working in Tabular model
Hello, I've implemented a simple tabular model using SQL Server 2012 SP1 SSDT with a date dimension that has an active relationship with the date key in the fact table and has ...Proposed | 1 Replies | 58 Views | Created by blezin - Thursday, February 26, 2015 10:37 PM | Last reply by Marco Russo - SQLBI - Friday, February 27, 2015 7:41 AM -
0 Votes
Regardnig the Cube Processing.
Hello Team, When I tried to process the cube, am getting the folowing window, which ...Proposed | 1 Replies | 65 Views | Created by Kumar Pradeep M - Thursday, February 26, 2015 11:31 PM | Last reply by Venkata Koppula - Friday, February 27, 2015 7:24 AM -
2 Votes
It's time for the TechNet Wiki SSAS "Great Guru Love-in"! You too can get some loving!
February at TechNet Wiki usually involves a lot of love... We love to read. We love to learn. We ...Discussion | 3 Replies | 190 Views | Created by XAML guy - Monday, February 09, 2015 9:16 PM | Last reply by Ed Price - MSFT - Friday, February 27, 2015 7:09 AM -
0 Votes
How data will storing in Cubes
Hi experts, How the data is storing in cubes, like SQL server data are storing in Page and extents. SO how in SSAS ...Proposed | 2 Replies | 62 Views | Created by DevBi - Friday, February 27, 2015 4:42 AM | Last reply by PrajapatiNeha - Friday, February 27, 2015 4:59 AM - Items 1 to 20 of 35865 Next ›
