For SSAS Cube process,we need create fact table.
In sql server 2008,we have table source in Dynamics nav,in sql server we have a master table for company
it contains 18 company's like 'A','B','C','D','E',..etc.
each company have separate transaction tables,for example in company A have valueentry table but table name like A$Valueentry,same table in company B in B$Valueentry also for Company C$Valueentry,D$Valueentry,E$Valueentry....
my situation is i need to insert the sales amount from A$valueentry,B$Valueentry,C$Valueentry..etc table to fact table(like staging query).how to loop this insert query for all company's.