How can Cubes speak to each other? Building up interactive Cubes.
hello,
building data warehouse in sql-server 2012. olap analysis shall run in powerpivot (and maybe calculations).my source system ms dynamics nav 2009r2.
in model want create 3 cubes sales, inventory, production, related each other.
means, once enter plannning values sales amount, want inventory cube show me planed values of sales cube + reserve selected time period (days, month, years).
in project before tried solve such problem usage of trigger directly write new dataset inventory cube, once new dataset entered in sales cube. bringing down performance.
question:
how can make cubes interactive?
use 1 table sales, production , inventory values?
there function allows me use start , end values inventory can used in scaleable olap analysis?
thank help!
regards jörg
building data warehouse in sql-server 2012. olap analysis shall run in powerpivot (and maybe calculations).my source system ms dynamics nav 2009r2.
in model want create 3 cubes sales, inventory, production, related each other.
means, once enter plannning values sales amount, want inventory cube show me planed values of sales cube + reserve selected time period (days, month, years).
in project before tried solve such problem usage of trigger directly write new dataset inventory cube, once new dataset entered in sales cube. bringing down performance.
question:
how can make cubes interactive?
use 1 table sales, production , inventory values?
there function allows me use start , end values inventory can used in scaleable olap analysis?
thank help!
regards jörg
since these seem related, add these 1 cube, separate measure groups. plan 4th measure group. can have sort of calculated members using data.
SQL Server > SQL Server Analysis Services
Comments
Post a Comment