Analysis Cubes displaying "Unknown" for dates

(0) Share

Report

Posted on by Community Member

Hi,

I installed Analysis Cubes for a client but there is a problem with the date fields as they are all displaying "Unknown". I have tried redeploying the cubes but this has not solved the problem. I can see the dates in the database.

What could be causing this ?

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Leahs on at

Like (0)

Report

Is the Master Package Job running successfully?
Try manually running the package and verify it completes without error. To run the Master pack in SQL Server Management Studio > connect to Integration Services > Stored Packages > MSDB > Dynamics GP Warehouse > Right click on the job ending in Package_Master > Run Package > Execute
If an error is returned please reply back with screen shots of all the errors returned. The last error message returned when the job completes will state the package has failed. You will need to scroll up in the Package Execution Process Window to see the originating error(s).

Was this reply helpful? Yes No
Verified answer

Redbeard 12,931 on at

Like (0)

Report

Tracy,

I encountered the same problem after installation. I went through and redeployed the cubes as well, and experienced much the same result.

First, I checked BIDS, and was able to validate I had data in the tables by Double Clicking on the Cubes, Opening the Cube Structure, then Right Clicking on various tables and selecting Explore Data (this previews the tables) - you should see data in Dimensions. If you can do this, then you know the data is not the problem.

After validating the data was not the problem, I connected to the Microsoft Analysis Server, then Right Clicked on the Dynamics GP Analysis Cubes at the top level and select Process, then click OK. This refreshed the Entire Analysis Cube Structure. I was then able to go into Excel and click Refresh Data, and the Unknowns disappeared.

I really hope this works for you as well.

Was this reply helpful? Yes No
adeel333 487 on at

Like (0)

Report

Harry Lee I have the same problem. Analysis cubes GP 2010 and all of my Dates dimension showing UNKNOWN. I have went through your recommended solution but unable to resolve the issue. All other dimensions are showing accurate data. Please help.

Was this reply helpful? Yes No
Suggested answer

adeel333 487 on at

Like (0)

Report

Finally it worked for me.

redbeardblogging.blogspot.com/.../dynamics-gp-analysis-cubes-deployment.html

Everything is working fine now :)

Was this reply helpful? Yes No