February 17, 2017 at 2:10 am
We are trying to make SSAS description fields available in our pivot explorer as an instant user documentation. DMV queries is the attempted method of extracting the information.
Descriptions of dimensions ($system.mdschema_dimensions) are available.
Descriptions of measure groups ($system.mdschema_measuregroup_dimensions) and measures ($system.mdschema_measures) are empty even if the description field is filled in.
I don't know if the problem is deploying the description fields to SSAS or if the DMV queries fails to retrieve the fields from SSAS.
If the DMV queries is the problem, this might be solved by using XMLA, but that's a bit beyond my knowledge.
I'm using Visual Studio Community 2015 (14.0.24720.00 Update 1) and SSAS 2014 (12.0.4100.1).
Any suggestions anyone?
February 17, 2017 at 11:46 am
hjalmjall - Friday, February 17, 2017 2:10 AMWe are trying to make SSAS description fields available in our pivot explorer as an instant user documentation. DMV queries is the attempted method of extracting the information.Descriptions of dimensions ($system.mdschema_dimensions) are available.
Descriptions of measure groups ($system.mdschema_measuregroup_dimensions) and measures ($system.mdschema_measures) are empty even if the description field is filled in.I don't know if the problem is deploying the description fields to SSAS or if the DMV queries fails to retrieve the fields from SSAS.
If the DMV queries is the problem, this might be solved by using XMLA, but that's a bit beyond my knowledge.
I'm using Visual Studio Community 2015 (14.0.24720.00 Update 1) and SSAS 2014 (12.0.4100.1).
Any suggestions anyone?
Have all the objects been processed?
Sue
February 23, 2017 at 5:36 am
Sue_H - Friday, February 17, 2017 11:46 AMhjalmjall - Friday, February 17, 2017 2:10 AMWe are trying to make SSAS description fields available in our pivot explorer as an instant user documentation. DMV queries is the attempted method of extracting the information.Descriptions of dimensions ($system.mdschema_dimensions) are available.
Descriptions of measure groups ($system.mdschema_measuregroup_dimensions) and measures ($system.mdschema_measures) are empty even if the description field is filled in.I don't know if the problem is deploying the description fields to SSAS or if the DMV queries fails to retrieve the fields from SSAS.
If the DMV queries is the problem, this might be solved by using XMLA, but that's a bit beyond my knowledge.
I'm using Visual Studio Community 2015 (14.0.24720.00 Update 1) and SSAS 2014 (12.0.4100.1).
Any suggestions anyone?
Have all the objects been processed?
Sue
All dimensions and measures have been processed.
Hjallmar
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply