Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
moni
Starting Member
1 Post |
Posted - 2011-07-20 : 09:13:14
|
Hi I had created a cube using SSAS 2005 and we had the fact_view and Prod_dim view,Store_dim view,Calendar_dim view and Promotion dim_view as i had created the cube i had the mesures like volume and Turnover.we are getting the volume and Turnover corrrectly but now my Question is like while Processing the cube in the Query it is only picking the values from the fact file.Is that correct to Pick the data only from the Fact File.And other Query is like can anyone please explain me in detail how we can create the Partions in SQL 2005.AS i am not able to find anywhere in Google.And in my case to create the Partion i am not geting the Option as my SSAS solution is only Picking the FAct file and not showing any Calendar Dimeions views .Please help |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-07-20 : 09:28:08
|
what do you mean by picking up values? Also were you using a process data or process full option for cube processing?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|