Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4
Default Stacked Sum From an OLAP Cube

Lets say you have to plan capacities for two Teams per Week over two months.
For each week you have got target values and actual values in hours (h).
A table can look like this in 2008 for week 27 and 28:

Week 27:
Team A, actual 3h, target 2h
Team B, actual 4h, target 1h


Week 28:
Team A, actual 2h, target 2h
Team B, actual 2h, target 1h

Actual and Target are Measures in the cube. Lets build a chart that displays
the actual as bars and the target as points.
The * is the point for target/Team A and O is the point for target/Team B
The chart looks like this in beautiful ASCII:

4 -+- +----+
| | B |
3 -+- +----+ |
| | A | |
2 -+- | | | * +----+----+ *
| | | | | A | B |
1 -+- | | | O | | | O
| | | | | | |
0 -+---+----+----+-------------------+----+----+-------------
Year 2008
Week 27 Week 28

A = Team A
B = Team B
* = target/Team A
O = target/Team B

Now the QUESTION/PROBLEM I have got:
I want to Sum target/Team A and target/Team B in ONE Value that is called
"Overall target". But because I am using Data from an OLAP-Cube I cant Modify
data or the data-range. So it seems the calculated sum must be delivered from
the sube.
But the Measure "target value" is alway split up for Team A and Team B
separately and I cant stack it up.
Even if I create a variable in the Cube that sums up the target values for
the teams it gets split up in the chart.

The goal is that the chart looks like this:
4 -+- +----+
| | A |
3 -+- +----+ | @ @
| | | |
2 -+- | | | +----+----+
| | | | | A | B |
1 -+- | | | | | |
| | | | | | |
0 -+---+----+----+----------------- +----+----+-------------
Year 2008
Week 27 Week 28

A = Team A
B = Team B
@ = Overall target (so @ = * + O respectively 3 = 2 + 1

A long Question I know, but I would really be glad if you could help me out!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
olap data cube John Excel Discussion (Misc queries) 0 June 25th 08 01:12 PM
suppress warning and locate cube in a pivot table from olap cube Tewari Excel Discussion (Misc queries) 0 March 28th 07 06:54 AM
GETPIVOTDATA from OLAP cube [email protected] Excel Discussion (Misc queries) 3 August 15th 06 08:23 PM
olap cube little bear Excel Discussion (Misc queries) 1 February 16th 06 03:55 AM
OLAP cube and formula z00 Excel Discussion (Misc queries) 0 January 19th 05 03:44 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"