You’re offline. This is a read only version of the page.
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
Finally it worked for me.
redbeardblogging.blogspot.com/.../dynamics-gp-analysis-cubes-deployment.html
Everything is working fine now :)
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.
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.
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).
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
