No announcements
Found 3973236 threads
-
0 VotesAfter adding a new attribute to a dimension and saving, SSAS unprocessed partitions.
Whenever you change the structure of a dimension (i.e. adding a new attribute or deleting a attribute), any fact tables that are related to that ...Answered | 1 Replies | 5946 Views | Created by hgfg - Thursday, October 28, 2010 4:49 PM | Last reply by Frank Kearney - Thursday, October 28, 2010 6:28 PM
-
0 Votes
adding and change the dimension attributes in existingcube
Here som examples when u need to full ...Answered | 1 Replies | 932 Views | Created by sheshu0022 - Monday, January 19, 2015 9:15 AM | Last reply by yger - Tuesday, January 20, 2015 11:53 AM -
0 Votes
Unprocess cube old partition
Hello: i have 2 technical questions about the unprocess of a partition...i would really appreciate if you could answer them as possible as they can..Answered | 5 Replies | 6700 Views | Created by Arif Coskun - Saturday, September 4, 2010 8:42 PM | Last reply by Brerick - Thursday, January 23, 2014 9:19 PM -
2 Votes
Issue with dimension and partition processing
Your answers were really helpful.Answered | 3 Replies | 2119 Views | Created by Banash - Tuesday, November 13, 2012 7:58 PM | Last reply by Banash - Wednesday, November 14, 2012 2:00 PM -
0 Votes
Adding attributes to SSAS dimension without BIDS
Hi Palash, Check following thread where you can find the AMO code for adding new attribute.Answered | 4 Replies | 3408 Views | Created by Palash Aich - Wednesday, February 22, 2012 4:39 PM | Last reply by Aniruddha Thengadi - Friday, February 24, 2012 9:09 AM -
2 Votes
Adding New Dimension
Hi Khidir, You can create a new dimension based on the Fact table and it is called the Degenerated ...Answered | 5 Replies | 1123 Views | Created by khidir - Monday, September 28, 2015 11:55 AM | Last reply by Venkata Koppula - Tuesday, September 29, 2015 7:03 AM -
5 Votes
Do you have to ProcessIndex on dimensions or partitions after ProcessUpdate dimension?
Hopefully these DMV's will at least provide some visibility into what is happening.Answered | 18 Replies | 15482 Views | Created by Lee Cascio - Monday, July 20, 2009 4:36 AM | Last reply by Andrej Kuklin - Wednesday, August 24, 2011 11:03 AM -
1 Votes
SSAS 2008 R2 reading all partitions
Attribute Relationship Type within the Dimension designer.Answered | 11 Replies | 1814 Views | Created by anumala - Tuesday, April 29, 2014 2:32 PM | Last reply by Kieran Patrick Wood - Wednesday, April 30, 2014 3:26 PM -
0 Votes
ssas displaying latest dimension attribute
Hi, if you use surrogate key , when a new record arrive in dimension , old one is expired and new arrive attribute mark as a current and ...Answered | 3 Replies | 1197 Views | Created by ScottCabral - Tuesday, June 30, 2015 2:21 AM | Last reply by ScottCabral - Tuesday, June 30, 2015 3:35 PM -
1 Votes
SSAS 2008 -- Why is metadata so slow???
Can someone help me?Answered | 54 Replies | 29562 Views | Created by Lee Cascio - Tuesday, June 9, 2009 7:42 PM | Last reply by Darren Gosbell - Friday, July 15, 2011 1:18 AM -
0 Votes
SSAS Tabular 2017 Proces Partition
If there are only new records added to you table(without update or delete), then you can just use the processing add option to achieve this(No need to ...Answered | 6 Replies | 1159 Views | Created by JeroenKneppers - Friday, August 3, 2018 1:08 PM | Last reply by Bob_Tang - Wednesday, August 8, 2018 11:08 PM -
0 Votes
Cube "Process State" changing to UnProcessed
I mean you can do process default on all dimensions and then you can still use the cube, and the cube’s state should be ‘processed’.Answered | 8 Replies | 18420 Views | Created by Michael Schreuder - Wednesday, January 20, 2010 11:28 AM | Last reply by robinseatec - Monday, July 12, 2010 5:54 AM -
3 Votes
Change the display of an attribute of a dimension in an ssas cube
You can add a column called SalesDescription in the underlying database dimension table as Richard said.Answered | 4 Replies | 2806 Views | Created by AsmaGh - Thursday, May 11, 2017 3:42 PM | Last reply by AsmaGh - Friday, May 12, 2017 9:46 AM -
0 Votes
Modifying an attribute value in SSAS dimension
Hi, You can play with attributes at DSV level.Answered | 1 Replies | 6032 Views | Created by Rahul_DWH - Wednesday, December 29, 2010 11:00 AM | Last reply by Santosh Kumar Joshi - Wednesday, December 29, 2010 11:53 AM -
0 Votes
Analysis Services and Referenced Dimensions
What I've found out is that for both attributes SSAS generates SQL query that joins Customer dimension to Date dimension by CreatedDateKey (in fact, by ...Answered | 11 Replies | 6875 Views | Created by Trevor Howe - Friday, January 14, 2011 9:54 AM | Last reply by GregGalloway - Thursday, February 3, 2011 1:56 PM -
0 Votes
adding a new attribute present in a dimension to another dimension
You can refer to this link to know some possible ...Answered | 2 Replies | 2457 Views | Created by Bharath_ram4u - Tuesday, November 15, 2011 9:27 AM | Last reply by Challen Fu - Thursday, November 17, 2011 8:58 AM -
0 Votes
please help me to understnad why we use same table name at 3 different places in SSAS Cube and what happens when we change table name in any of the place
This can be beneficial to other community members reading this thread.Answered | 6 Replies | 1028 Views | Created by ScriptSoft - Friday, October 11, 2019 8:11 AM | Last reply by ScriptSoft - Thursday, October 17, 2019 3:14 AM -
2 Votes
Why ``DefaultMember`` belongs to attribute instead of dimension?
After Alexei gave the explanation, I will remind you that every attribute is a hierarchy by default .Answered | 7 Replies | 747 Views | Created by kazakevichilya - Tuesday, August 23, 2016 12:47 PM | Last reply by kazakevichilya - Wednesday, August 24, 2016 1:50 PM -
0 Votes
Some keys are missing in SSAS cube dimension
No, when you process a dimension SSAS will load all the rows.Answered | 7 Replies | 4670 Views | Created by Zee Ash - Thursday, November 29, 2012 3:48 AM | Last reply by Elvis Long - Thursday, December 6, 2012 1:37 AM -
0 Votes
Processing configuration for Dimensions and Facts
I have spoken to our DBAs and they are suggesting full processing the dimensions after each release.Answered | 2 Replies | 4300 Views | Created by amir tohidi - Thursday, May 17, 2012 8:47 AM | Last reply by amir tohidi - Thursday, May 24, 2012 3:43 PM - Items 1 to 20 of 3973236 Next ›
No announcements
