| |
Data Dynamics Analysis Support
Started by kekorolim at 03-16-2010 3:14 PM. Topic has 6 replies.
  
|
|
Sort Posts:
|
|
|
|
 03-16-2010, 3:14 PM
|
kekorolim
Joined on 03-15-2010
Posts 4
|
|
|
Friends,
I would like to know how can I make to have hierarchy in an attribute through an instruction SQL for a relational data base, after that rescuing of the archive Schema and Analysis.As the example, the NwindMDB-SalesProductsSuppliers.schema archive is connected to the relational data base NWIND.MDB, and the archive Average Unit Price vs Total Product Cost.analysis possesses the attribute Product Categories composed of the attribute Category and Product, qualifying drill down and drill up in the line, as print screen attached.
|
|
|
|
|
Report
|
|
|
|
|
03-18-2010, 11:30 AM
|
woodoo
Joined on 03-15-2005
Posts 36
|
|
|
|
Hi my friend
I programmed 3 tools:
1: firstit connector
2: firstit schemabuilder
3: firstit analyser
the connector makes an xml file to connect to the database and is used for the schemabuilder (called schemacreator) and also the analyser
with the analyser you have a wysiwyg editor to creatore the sql-source, generate queries for the analyser-query-form and set the parameters for hierarchies, fieldnames, groups and more...
you want to use it for yourself or for reselling ?
for yourself, i can sel you the link for install the tools.... oderwise, i seek for resellers !!
Greetings from switzerland
|
|
|
|
|
Report
|
|
|
|
|
03-18-2010, 1:52 PM
|
kekorolim
Joined on 03-15-2010
Posts 4
|
|
|
|
Hi woodoo,
thanks for your attention. Yes, i´ll use it for myself. Could you send to me the link for install that tools ?
Regards
|
|
|
|
|
Report
|
|
|
|
|
03-18-2010, 2:05 PM
|
AashishB
Joined on 12-11-2008
Posts 818
|
|
|
|
kekorlim,
creating Hierarchies in Schema is fairly easy. Please take a look at this following article in the documentation which
provides more information:
If you need more assistance, please do not hesitate to ask.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
03-19-2010, 1:01 PM
|
kekorolim
Joined on 03-15-2010
Posts 4
|
|
|
|
Friends,
I believe that I did not make me understand well… I have an application where the user will go to type a command SQL, and after that generate the Schema archive and Layout futurely, by the C# code. Therefore, I don't know which involved tables and which involved fields to generate the hierarchy in time of execution through C# code … except that I create plus a screen where the user will go to say which fields will be part of an hierarchy… some suggestion? woodoo, and the link that you suggest me?
Regards,
|
|
|
|
|
Report
|
|
|
|
|
03-23-2010, 8:25 AM
|
kekorolim
Joined on 03-15-2010
Posts 4
|
|
|
|
AashishB,
could you help me please.
|
|
|
|
|
Report
|
|
|
|
|
03-24-2010, 3:46 PM
|
AashishB
Joined on 12-11-2008
Posts 818
|
|
|
|
Hierarchy contains levels, and every level has their own expression. A hierarchy with two levels will work similar to two corresponding attributes.
So if you choose attributes, which is not correlated (from absolutely different tables) you will see grid without data. Therefore you need to simply define necessary query fields (it can be column of the SQL query or calculated field with your own
expression) and then combine any levels in hierarchy. If underlying business objects are correlated and has relation, then you will see the desired output.
Regards,
Aashish
|
|
|
|
|
Report
|
|
|
|
|
GrapeCity » Product Support » Data Dynamics A... » Hierarchy
|
|
|
|
|