Henrik could help me a lot. This is great. Maybe you can help me with a last issue :-)
I want to merge the two tables Tree and Treebridge.
Because I just need some Fields, that you can find in the attached qvw-file
Afterwards I can drop the Nodes_tmp-Table.
Thanks a lot in advance.
I don't think that's a good idea...
- The Nodes_tmp table has exactly one record per node (691 records), and this is the proper place to keep all data pertaining to the nodes, including things like costs, account number, etc.
- The TreeBridge table has exactly one record per combination of node and ancestor (5698 records).
- The Tree table has exactly one record per node (691 records) but these have a different role than the Nodes in the first table. Each Tree record links, on the average, to 8 nodes.
If you start joining tables, you will get a data model that may show incorrect numbers and in addition uses more memory. So why should you do this? Further, if you drop the Nodes table, you will not be able to see relevant data, e.g. which assets you have within a sub-tree. I think that you right now have the optimal data model.
See also To Join or not to Join
I understand your Point. Thanks for that.
But I have an issue regarding that.
Beginning from Line 190 in the Excel until 425 I have Profit-and-Loss-Values.
These should go into BS33020 (but WITHOUT the Hierarchy, just as a single line-value)
I wanted to get rid of Information (that are not neccessary for me) to include the sum of all P&L-Values as one line and not as Hierarchy.
Do you have an Idea how can I do that?
I would load that Excel sheet in two rounds, with where clauses, so I get exactly the tables I want. E.g.
Load... From ... Where Left(NodeID,2) = 'BS';
Load... From ... Where Left(NodeID,2) = 'PL';
But I don't understand how you want to link the second part with the first.