No announcements
Found 1027712 threads
-
0 VotesChange OLAP Cube Build Job Owner
The service account running Analysis Services builds the cubes, so you may need to change this using SQL Server Management Studio.Answered | 2 Replies | 9184 Views | Created by Kathy Reyes - Monday, April 11, 2011 6:33 PM | Last reply by Kathy Reyes - Tuesday, April 12, 2011 3:24 PM
-
0 Votes
Sorting attribute in a cube based on another attribute
Another option for you is to create additional hierarchies with the first level the attribute you want to sort by, and the second level would always be the product.Answered | 4 Replies | 4916 Views | Created by PXPRXR - Tuesday, February 14, 2017 6:02 PM | Last reply by RichardLees - Thursday, February 23, 2017 3:00 AM -
0 Votes
Deploying cube dimensional structure changes to production
Deploy model changes - cube become inaccessible at this moment.Answered | 4 Replies | 1693 Views | Created by nihcas7713 - Sunday, April 5, 2015 12:23 AM | Last reply by Piotr Palka - Monday, April 6, 2015 4:50 AM -
0 Votes
Is there any way to change a Cube ID, or make SSIS connect using the cube name instead of the cube ID?
The only way to change the Cube ID is to recreate the cube using the XMLA script like Kalman said above.Answered | 2 Replies | 5461 Views | Created by Katherine Harverson - Friday, January 15, 2010 11:31 AM | Last reply by Frank Kearney - Friday, January 15, 2010 9:20 PM -
0 Votes
Changing the aggregation function while browsing SSAS cube
Hi Palash, It seems you are working with a simple cube - you usually wouldn't want to support this as measures could have all kind of calculations and aggregations applied ...Answered | 3 Replies | 6998 Views | Created by Palash Aich - Monday, March 7, 2011 9:57 AM | Last reply by HrvojePiasevoli - Tuesday, March 8, 2011 1:19 PM -
1 Votes
Value should not change upon applying Filters in a cube?
Should I change the name of this new calculated member.Answered | 10 Replies | 2895 Views | Created by SQL2012BI - Wednesday, December 28, 2011 4:53 AM | Last reply by SQL2012BI - Tuesday, January 3, 2012 12:33 PM -
0 Votes
Cube process crashes after changing to dimension updates
1) Process update on dimensions that are linked with the fact table SALES Process full on other ...Answered | 2 Replies | 903 Views | Created by Yvanlathem - Tuesday, April 14, 2015 8:54 PM | Last reply by Yvanlathem - Wednesday, April 15, 2015 5:57 AM -
0 Votes
How to deploy SSAS cubes to another analysis server?
I want to know is it possible to use SSAS cubes in another tools?Answered | 3 Replies | 6625 Views | Created by farhad koohbor - Tuesday, April 26, 2011 2:15 PM | Last reply by Javier Guillen - Saturday, April 30, 2011 6:37 PM -
0 Votes
change default backup directory for SSAS cubes
Once you open your properties, make sure you check (at the bottom) "Advanced" It opens more options to change paths.Answered | 4 Replies | 2366 Views | Created by kvd123 - Tuesday, April 17, 2018 1:57 AM | Last reply by AlopezBI - Tuesday, April 17, 2018 6:42 PM -
0 Votes
Copying multidimensional data (OLAP cubes) from one SSAS DB to another
Hi, I have two similar SSAS databases one of which is a test database intended to check all the changes I make and another one is a final database.Answered | 1 Replies | 3160 Views | Created by Wildfire93 - Thursday, April 5, 2012 12:44 PM | Last reply by Koen Verbeeck - Thursday, April 5, 2012 1:18 PM -
0 Votes
SSAS - Deploying changes with Dynamic cube partition
HI We have a cube partitioned dynamically on date.Answered | 3 Replies | 5649 Views | Created by grahan007 - Friday, February 24, 2012 9:53 AM | Last reply by Naveen Das - Friday, February 24, 2012 4:35 PM -
0 Votes
Cube design
All that is needed is to create different windows accounts that will do the processing of client cubes.Answered | 5 Replies | 3172 Views | Created by SSAS BT - Wednesday, August 24, 2011 10:36 AM | Last reply by HrvojePiasevoli - Wednesday, August 24, 2011 4:54 PM -
0 Votes
Cube Processing
But there are some restriction on it: - dimension don't have "rigid relation" - incremental means, you can only add new data, ...Answered | 2 Replies | 2465 Views | Created by Sarah2005 - Wednesday, June 27, 2012 8:03 PM | Last reply by Arun C - Thursday, June 28, 2012 7:21 AM -
2 Votes
How to anonymize all data in a cube - UPDATE CUBE?
" If you are in ROLAP; you could indeed change the data in the Source Database and it will reflect that.Answered | 7 Replies | 2069 Views | Created by Bluntek - Tuesday, November 5, 2013 5:15 PM | Last reply by Bluntek - Tuesday, November 12, 2013 11:19 AM -
0 Votes
Overwriting each others changes when serveral developers work on the same cube
I was hoping to find something ( a tool , a process... whatever works) that allows to merge all the changes made from each developer into the ...Answered | 3 Replies | 2728 Views | Created by Ludwig AR - Wednesday, November 23, 2011 7:46 PM | Last reply by Ludwig AR - Monday, November 28, 2011 4:58 AM -
0 Votes
CHanges to application not pushing out
If you are changing anything in menus \ tabs then you do not need to update the content on the DP, once the clients update policy they will automatically see the ...Answered | 3 Replies | 486 Views | Created by BigDook - Friday, April 10, 2015 12:15 AM | Last reply by Richard.Knight - Friday, April 10, 2015 8:23 AM -
0 Votes
Excel error after moving cube from one server to another
This .Odc is hosted in SharePoint (You may be able to host in somewhere else, i'm not 100% sure), every time the Excel Document is opened the .Odc file is refreshed and the new connection ...Answered | 1 Replies | 827 Views | Created by rpfinn - Monday, February 1, 2016 2:44 PM | Last reply by MichaelAdrianJohnson - Monday, February 1, 2016 4:34 PM -
0 Votes
Rename a cube in SSAS 2008
Instead of backing up the cube and restoring it with a different name, I'd prefer to rename the existing cube and then deploy another cube with the original name.Answered | 5 Replies | 6732 Views | Created by JonesLondon - Saturday, April 14, 2012 1:10 PM | Last reply by Jerry Nee - Wednesday, April 18, 2012 10:29 AM -
3 Votes
What is the difference between Cube deployment and Cube processing?
When following the tutorials in Books Online, it often states to just Deploy dimension or cube changes and then browse the dimension or cube to see the results.Answered | 6 Replies | 14138 Views | Created by Shivendoo Kumar Dubey - Wednesday, July 8, 2009 6:30 AM | Last reply by CindyPsych - Friday, February 12, 2010 5:30 PM -
1 Votes
How to delete data of cube
You would simply use the Unprocess option and it should be very quick - you don't need to change any of your source data.Answered | 2 Replies | 7426 Views | Created by Amit Srivastava - Thursday, December 16, 2010 10:45 AM | Last reply by Darren Gosbell - Friday, December 17, 2010 6:41 AM
No announcements
