PivotTable Total from Database

hi,
i'm trying to create a PivotTable in which I will be able to see totals coming from the database, not a calculated total field performed by the PivotTable. The data are structured with a hierarchical dimension for wich values are existing for each low level detail item and also for the high level detail item.
Is it possible to create a PivotTable based on a ROLAP(with SQL query) access that provide this kind of result (with total from the database).
For example, with the following table of data, I want to produced a PivotTable with 2 columns (E1Dim2 and E2Dim2 values) and 2 rows (E1Dim1 and E2Dim1 values). The PivotTable values are 100 for each dimension elements combinaison (the totals from database). Sure, I need to be able to drill one values on the row axis to see E11, E12 and E13 detail values.

id_meas1 val1_meas1 val2_meas1 des_dim1 des_dim11 des_dim2 1 10.23445 12.23445 E1Dim1 E11 E1Dim2 2 100 100 E1Dim1 E1Dim2 3 12.43356 13.34424 E1Dim1 E12 E1Dim2 4 14.34455 12.34234 E1Dim1 E13 E1Dim2 5 9.23423 8.53464 E1Dim1 E11 E2Dim2 6 100 100 E1Dim1 E2Dim2 7 10.23452 9.43234 E1Dim1 E12 E2Dim2 8 14.4532 12.3423 E1Dim1 E13 E2Dim2 9 8.23423 12.53464 E2Dim1 E11 E1Dim2 10 100 100 E2Dim1 E1Dim2 11 9.23452 14.43234 E2Dim1 E12 E1Dim2 12 12.4532 11.3423 E2Dim1 E13 E1Dim2 13 12.23423 13.53464 E2Dim1 E11 E2Dim2 14 100 100 E2Dim1 E2Dim2 15 10.23452 10.43234 E2Dim1 E12 E2Dim2 16 11.4532 12.3423 E2Dim1 E13 E2Dim2

Is it possible to get this behavior with ROLAP access?
Jeff

ROLAP is only storage mode you choose for your dimensions and partitions.

You should be able to change storage mode to ROLAP and continue to work as you were in MOLAP. The data you reciveing and the way you receive it should be the same.

Word of caution here:
If you are operating with large amounts of data you might get slower performance for your ROLAP dimensions and partitions.
Also during processing of MOLAP dimensions and partitions Analysis Server hides some of referential integrity problems you might have in relational database. Switching to ROLAP might surface these problems.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||my questionning is about how can I display TOTAL VALUES comming from database, not totals calculated by the pivottable?
I'm trying to create a pivottable in wich the detail and total values providing from database and not calculated by the pivottable. And I have a technological constraint, is to using MS-Access database, thus using SQLQuery and not MDX.

Is it possible to present detail values associate with the lower items level dimension and the total values associate with the higher items level dimension, without using total in the pivottable?

|||

Using Excel you can acomplish a lot. I am sure you should be able to find a solution for your problem.

This is probably a wrong forum for you question. Try and post it on the microsoft.public.excel newsgroup.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.