July 10, 2018 at 11:29 am
Hello, I have a 1200 (2016) Tab cube that I was able to get loaded to a certain fact table that is a data partition, the data partition shows the row count and current load date, however when I connect Excel to the cube to examine the data content of that folder, there is no data. The cube does have data in the other dims as well. I even did a full process on that data cube, and I still can't get any data to display in Excel from that cube, yet all other indicators show that it has data.
What should I check, do, or try to remedy this issue? What other info can I provide to highlight anything suspect?
Thank you
July 10, 2018 at 3:33 pm
quinn.jay - Tuesday, July 10, 2018 11:29 AMHello, I have a 1200 (2016) Tab cube that I was able to get loaded to a certain fact table that is a data partition, the data partition shows the row count and current load date, however when I connect Excel to the cube to examine the data content of that folder, there is no data. The cube does have data in the other dims as well. I even did a full process on that data cube, and I still can't get any data to display in Excel from that cube, yet all other indicators show that it has data.
What should I check, do, or try to remedy this issue? What other info can I provide to highlight anything suspect?
Thank you
Issue resolved, simply not enough of the data I was looking for was there for that month to validate, backed up a month, all is well
July 10, 2018 at 11:39 pm
quinn.jay - Tuesday, July 10, 2018 3:33 PMquinn.jay - Tuesday, July 10, 2018 11:29 AMHello, I have a 1200 (2016) Tab cube that I was able to get loaded to a certain fact table that is a data partition, the data partition shows the row count and current load date, however when I connect Excel to the cube to examine the data content of that folder, there is no data. The cube does have data in the other dims as well. I even did a full process on that data cube, and I still can't get any data to display in Excel from that cube, yet all other indicators show that it has data.
What should I check, do, or try to remedy this issue? What other info can I provide to highlight anything suspect?
Thank youIssue resolved, simply not enough of the data I was looking for was there for that month to validate, backed up a month, all is well
Good stuff.
😎
Just a thought, you can use the SSAS DMVs to monitor the SSAS.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply