No data in cube

Who is online?  0 guests and 1 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » No data in cube

No data in cube

Topic RSS Feed

Posts under the topic: No data in cube

Posted: 8/2/2011

Padawan 136  points  Padawan
  • Joined on: 7/8/2011
  • Posts: 58

Hi all,

I rebuilt a fact table in the DW pulling data from another server. The data is in the DW. When I go to the cube to Deploy or Process it, no data is pulled up to the fact table in thecube. Any ideas?

 

Thanks


Posted: 8/3/2011

Jedi Master 5348  points  Jedi Master
  • Joined on: 10/27/2009
  • Posts: 208
Answered  Answered

A lot of things to troubleshoot because it's a generic problem so try these:

  • Can you preview the data in the data source view
  • Do you have security on the cube that could be preventing you from viewing
  • Are there any filters on the tables in the data source view
  • Are the dimension relationships complete in the dimension usage

Posted: 8/3/2011

Padawan 136  points  Padawan
  • Joined on: 7/8/2011
  • Posts: 58

Thanks Devin,

Got it to work just bi closing BIDS and reopening again.


Page 1 of 1 (3 items)