happy_smiler1
New member
- Joined
- Aug 28, 2012
- Messages
- 67
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
Hello guru's,
Im abit confused about olap cubes, or data cubes, is there a way of refreshing data that has been taken out of a cube in excel? Basically what im trying to learn is i know that an olap cube is a pivot table in excel and that you can quickly extract data from it, however, when i extract data from it, i would like it so that it automatically updates the data, so essentially like having a drop down box with options, once you click an option it will pull it from the cube, then every week or month, to change say a date and it will automatically refresh the pivot table and the data.
Hope its not confusing.
Hope to hear from the best soon.
Regards.
Im abit confused about olap cubes, or data cubes, is there a way of refreshing data that has been taken out of a cube in excel? Basically what im trying to learn is i know that an olap cube is a pivot table in excel and that you can quickly extract data from it, however, when i extract data from it, i would like it so that it automatically updates the data, so essentially like having a drop down box with options, once you click an option it will pull it from the cube, then every week or month, to change say a date and it will automatically refresh the pivot table and the data.
Hope its not confusing.
Hope to hear from the best soon.
Regards.