Replied 3 August 2017, 3:50 pm EST
First of all please note that ddAnalysis is not a new version of DynamiCube but a completely new and different product and as such we are not recreating DynamiCube with ddAnalysis. The \\Item\Caption node is used to define the caption of the field that would be displayed in the schema and on the shelves. The \\Item\CaptionExpression node can be used to set a caption for each member to include additional text (which could include member captions from other fields) or specify a different field from the data source that is related to the item's key field (i.e. the field referenced in the \\Item\Expression node). The caption expression will retrieve captions as the data is loaded. If your lookup table will be located in your database you can include it within your query. For example say you have a field, HealthCareID, for the code and another, HealthCareName, for the name of the company. Assuming that you are automatically generating an initial schema using the command line utility provided, you could modify the schema file changing the value of the \\Item\CaptionExpression node (that corresponds to the HealthCareID) from "=Fields!HealthCareID.Value" to "=Fields!HealthCareName.Value". Once this is done the field's XML should look similar to the following:
Also if the HealthCareID is included in the measures, you would need to move it to an attributes dimension within the schema file. You can also change its name by changing the value in the \\Item\name node.
If you are automatically generating the schema from the API, you would also need to perform a similar procedure. Assuming that the ID field is initially setup as a measure, you could "move" it to the attributes dimension, change the caption expression, and modify its name by using code similar to the following code snippet:
DataDynamics.Analysis.Schema.MeasuresDimBuilder myMeasureDimenBuilder = (DataDynamics.Analysis.Schema.MeasuresDimBuilder)sb.Dimensions["Measures"];
DataDynamics.Analysis.Schema.AttributesDimBuilder myAttributeDimenBuilder = (DataDynamics.Analysis.Schema.AttributesDimBuilder)sb.Dimensions["Attributes"];
DataDynamics.Analysis.Schema.AttributeBuilder myAtrtibuteBuilder = new DataDynamics.Analysis.Schema.AttributeBuilder("HealthCareProvider");
//remove the unneeded fields from the schema
If you have any further questions please feel free to let me know.