Hierarchy

03-16-2010, 3:14 PM
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.

Re: Hierarchy

03-18-2010, 11:30 AM
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

Re: Hierarchy

03-18-2010, 1:52 PM
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

Re: Hierarchy

03-18-2010, 2:05 PM
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

Re: Hierarchy

03-19-2010, 1:01 PM
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,

Re: Hierarchy

03-23-2010, 8:25 AM
AashishB,

could you help me please.

Re: Hierarchy

03-24-2010, 3:46 PM
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