link of two tables of facts: circular loop

[#1]

Dear Friends,

I Modify my answer

I have 2 tables for budget

1. BUDGAGE: Year / Employee / Sales

2. BUDGET: date / Material group / Sales

I have a problem of circular loop. I can't solve the problem

Can you help me??

gennaro

[pover]

This was a common problem I had in the beginning and I used to do macros, actions or a sum(if) expression to manually link the different dates in the interface, but when I started to consider the budget as just another transaction and concatenated the budget with real transactions life became easier. Of course, I created a flag to know which rows were budget amount and which were real amounts.

If you are looking for a master calendar example, too, just search the forum for master calendar and you will find some examples.

Regards.

[#3]

You were all very kind

I must learn to make better use of the forum

thanks a lot

regards

[#4]

Hi All,

excuse me but I can't solve the problem of circular loop

the master calendar is ok (I think) but the budget tables are in circle [:'(]

I tried to add the budget in table of documents, but creates other problems

can you help me??

thanks in advance

[Anonymous]

Your master calendar is connect through "Data" AND "Anno"

My suggestion:

Rename 'Anno" in the Budgage table:

Load:
Anno as AnnoBudgage

Just first try this to see what happens...

[Anonymous]

And what is SM? And does it need to be in all table, and does it need to be connected to each other?
If not just change the names of SM.
If it is connected try to merge them into 1 table.

[#7]

Hi Dennis,

ANNO is the year

if I rename this field how link the year o table Budgage with the calendar?

SM is a group of material and I have the budget for a single group.

I tried to add the budget in table of document but don't work

[Anonymous]

Hi Gennaro

Lets first strat with the first circle.
What you must do is bring the amount of tables back by combining the ones that have connected information. I don't know how which data is connected but you can do this by making one table by using RESIDENT and CONCATENATE.

For example:

NEWTABLENAME:
LOAD
 SM,
 D_SM
RESIDENT SETTORE;

CONCATENATE

LOAD
 DATA,
 SM,
 bdg_Valore
RESIDENT BUDGET;
CONCATENATE
LOAD
 SM,
 Material,
 D_material
RESIDENT MATERIALE;
DROP TABLE SETTORE;
DROP TABLE BUDGET;
DROP TABLE MATERIALE;

Let me know if this works for you.

[Anonymous]

If I am correct this will make 1 table instead of 3.
The new table has the SM fields from all 3 previous tables in 1 SM field plus all the other fields form these 3 tables.

The DROP TABLE deletes the 3 previous table after making the new table (as you don't need them anymore)

I hope this is some help for you.