Hi all,
I am trying to become friendly with Jet Enterprise (I already am an accompished JetEssentials user) and am wondering if there is a way to use Cubes as a datasource in JetEssentials, other than for generating PivotTables.
I was hoping to be able to just mildly change the standard reports I created in JetEssentials to make them run on the Cubes we designed. My first experiments suggest it is not possible, but I may be wrong.
Is it possible, or is it better to stop trying?
Willem
Date
Votes
1 comment
-
Jet Reports Historic Posts Hello Willem -
While the power of Jet Enterprise lies in the speed that is provides - and Excel's pivot capabilities complement that, extremely well - it is possible to use the Jet Excel add-in with Enterprise cubes.
Once a cube data source is defined:
You can define NL() functions much as you would with any other data source.
The table name is the name of the Cube you wish to use.
You can also use the NL("Cubevalue") function to return specific measures from you cubes:
If what you want to do is use the Jet Excel add-in to examine your data, I would suggest experimenting.
Have fun!
Please sign in to leave a comment.