No data neither in Warehouse database nor in cubes

(0) Share

Report

Posted on by Community Member

Hi,

I have installed the Analysis Cubes on my GP v2013 as per the instructions provided in here: http://jonathanpcox.com/2014/10/31/deploying-the-gp-2013-r2-analysis-cubes/.

Everything went good, and after installation, I can see the warehouse in the Database Engine and Cubes in Analysis Services.

But I don't know there are no rows / data neither in the warehouse database nor in the cubes.
Am I supposed to pull the data to warehouse database or to cubes? If so, how can I?
Can anyone please help me in this?

Many thanks in advance.

*This post is locked for comments

All responses (2)

Answers (2)

Verified answer

Community Member on at

Like (0)

Report

RE: No data neither in Warehouse database nor in cubes

Hi John!

YOU OPENED MY EYES. The actual issue was the SQL AGENT Service. It was stopped, and run the service, after that, everything went perfect.

Thanks for the correct hint at the correct time!

-

Mohamed Thaufeeq
Verified answer

John Lowther 5,122 on at

Like (0)

Report

RE: No data neither in Warehouse database nor in cubes

First let me ask a few questions, did you setup a scheduled job to populate the warehouse and build the cubes?

Did any SQL Agent Jobs get created that execute SSIS packages? These are created when you setup the schedule during install.

If you do have SQL Agent Jobs that where created during the install, what do you see when you select "view History" on those jobs?

Hope these questions gets you headed in the right direction.