December 6, 2017 at 1:42 pm
Hello, I have several data partitioned cubes, one that I copied that is in a 2016 tab instance, but the cube model is a 2014 1103 format. In the 1103 format, I can look into the properties of a dim table, and get MeasureID, PartitionID, etc, and insert this info into a Parition Table Dims type of table that works with SSIS packages that handles proper data partition processing. Through converting a copy and rename of a 1103 cube, to 2016 format, I seem to have lost looking up the properties to find the MeasureID, PartitionID, etc. Where can I find them now? Please let me know what additional details I can share. Thanks
December 6, 2017 at 11:42 pm
quinn.jay - Wednesday, December 6, 2017 1:42 PMHello, I have several data partitioned cubes, one that I copied that is in a 2016 tab instance, but the cube model is a 2014 1103 format. In the 1103 format, I can look into the properties of a dim table, and get MeasureID, PartitionID, etc, and insert this info into a Parition Table Dims type of table that works with SSIS packages that handles proper data partition processing. Through converting a copy and rename of a 1103 cube, to 2016 format, I seem to have lost looking up the properties to find the MeasureID, PartitionID, etc. Where can I find them now? Please let me know what additional details I can share. Thanks
Presumably you were running some sort of SSAS DMV query to get this data before. In 2016 there are new ones for Tabular: https://msdn.microsoft.com/en-us/library/mt704103(v=sql.105).aspx
I have no idea what you were running before so don't know why it is no longer working. Maybe you were using ASSP and you haven't added the assembly to your new instance? Maybe the functionality of the query has changed in 2016? Without the query it's just a guessing game. However if you try the new ones in the link I'm sure you'll get what you need.
December 7, 2017 at 10:21 am
PB_BI - Wednesday, December 6, 2017 11:42 PMquinn.jay - Wednesday, December 6, 2017 1:42 PMHello, I have several data partitioned cubes, one that I copied that is in a 2016 tab instance, but the cube model is a 2014 1103 format. In the 1103 format, I can look into the properties of a dim table, and get MeasureID, PartitionID, etc, and insert this info into a Parition Table Dims type of table that works with SSIS packages that handles proper data partition processing. Through converting a copy and rename of a 1103 cube, to 2016 format, I seem to have lost looking up the properties to find the MeasureID, PartitionID, etc. Where can I find them now? Please let me know what additional details I can share. ThanksPresumably you were running some sort of SSAS DMV query to get this data before. In 2016 there are new ones for Tabular: https://msdn.microsoft.com/en-us/library/mt704103(v=sql.105).aspx
I have no idea what you were running before so don't know why it is no longer working. Maybe you were using ASSP and you haven't added the assembly to your new instance? Maybe the functionality of the query has changed in 2016? Without the query it's just a guessing game. However if you try the new ones in the link I'm sure you'll get what you need.
I'll investigate the links you sent, but what I am seeing is that GUIDS went away with 2016, so thats why its not there when I converted from 2014 to 2017 flavor or Tab cube. And that I'm to only use or need the name of the data partition within the partition tables that work with the SSIS packages that run through the create/update/process logic of a given table that has data partitions to deal with
December 7, 2017 at 11:28 am
Well the IDs are still there; the XMLA standard has not changed. To quote Microsoft:
Every object has a Name and ID property that must be unique within the scope of the parent collection. For example, two dimensions can have same name as long as each one resides in a different database.
The ID property is auto generated. Since you don't mention precisely how you upgraded it's difficult to tell why you are seeing differences. If you can also post the queries that you are using as previously asked then maybe we can help further.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply