Elsasoft Forums
Elsasoft Forums
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SqlSpec
 Feature requests
 some SSAS feature requests
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Germo
New Member

73 Posts

Posted - Apr 10 2013 :  12:37:00 AM  Show Profile  Reply with Quote
Hallo,

here are some feature request / bugs for SSAS documentation.
used version: SqlSpec 6.8 (MS SQL 2012)

calculated measures:
- document them.
currently calculated measures are only documented if they are used in perspectives, but the column "measure group" is empty.
- associated measure group is not documented if it is part of the code. I think that's why they are missing in the cube documentation.
Example:
CREATE
MEMBER CURRENTCUBE.[Measures].[Date H Y-Q-M-D item 0] AS
[Date].[H Y-Q-M-D].[Day].Members.ITEM(0).Member_Key
,VISIBLE = 1
,DISPLAY_FOLDER = 'test'
,ASSOCIATED_MEASURE_GROUP = 'Avg Type' ;

Measures, calculated measures, dimension attributes:
- document display folders
- document visible

cubes:
- add a dimension usage matrix

Measure groups:
- document calculated measures associated to the measure group

Measure group partitions:
- document the code of the query if a query is used as datasource of the partition

dimension attributes:
- document key columns
- document name columns
- document xpathAttributeVisible: Attribute Visible
- document xpathAttributeEnabled: Attribute Enabled
- document xpathAttributeAttributeHierarchyDisplayFolder: Attribute Display folder

Regards
Germo

Edited by - Germo on Apr 10 2013 12:39:08 AM
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Elsasoft Forums © Elsasoft LLC Go To Top Of Page
Snitz Forums 2000