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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 SSAS

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 MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -