| |
Data Dynamics Analysis Support
Started by fedda at 02-26-2010 8:35 AM. Topic has 1 replies.
  
|
|
Sort Posts:
|
|
|
|
 02-26-2010, 8:35 AM
|
fedda
Joined on 02-23-2010
Posts 57
|
Attributes text in Pivotview
|
|
|
|
|
Hi,
I am currently porting a program from using DynamiCube to DDA.
My problem now is setting different pivotview layout names to the Measures names or the attribute names, then from the column names from the SQL database.
The DynamiCube had an add method, which took one param as the db column field name and one other to display in the view.
Public Function Add( ByVal sourceName As String, ByVal Name As String, ByVal location As OrientationConstants
) As Field
The closes thing i found in the DDA is this method:
myLayoutActions.InsertField("[Attributes].["CustNr"]", DataDynamics.Analysis.Layout.ShelfKind.RowShelf, rwCol.Rank)
But then the name of the “attributBox” in the RowShelf will become “CustNr”, which is not as good as I want it to be. Is it a better method of doing this or do I have to make a custom schemebuilder to fixs it? (Iam now using a automatic generated scheme file)
Description
Adds a new field to the collection.
Syntax
Public Function Add( _
ByVal sourceName As String, _
ByVal Name As String, _
ByVal location As OrientationConstants _
) As Field
Parameters
sourceName
The name of the field as it appears in the data source recordset. This is used as a key in the collection.
Name
The name of the field as it would be displayed in the DynamiCube view.
location
|
|
|
|
|
Report
|
|
|
|
|
02-26-2010, 9:09 AM
|
James Johnson - DD
Joined on 01-05-2006
Columbus, Ohio
Posts 502
|
Re: Attributes text in Pivotview
|
|
|
|
|
|
Hi,
You will need to alter your schema. By default the schema is generated using the names as the database fields. Under the covers, however the database field and the attribute/measure names are separate.
In the terminology of the schema, a Query Field is the value coming from the database. You can also create calculated query fields based off of these values. From the Query Fields you create the Attributes (and hierarchies) and Measures using expressions.
This section of the product help shows you how to create various parts of a schema through code. You can also open the .schema file and edit its XML manually.
James
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Re: Attributes text in Pivotview
|
|
|
|
|