A Chart for Each Client

I'm trying to create a chart for each client.
In a DataSet, they are returned in a sorted order like this:
ClientName Month Sales
-- -- --
Client 1 1 500
Client 1 2 100
...
Client 1 10 900
Client 2 1 100
Client 2 2 200
...
Client 2 10 800
I'd like to have two charts, Client 1 and Client 2 showing their own
trend.
However, so far I get only ONE chart, either a sum, or the first client
group if it's not sum.
I don't think it will take one query per client.
Thanks.I think I got it by browsing some QA here, simply by putting it in a
group's header or footer in a table.|||Yes, that is correct. If you place a chart in a table detail section, every
chart will just get one detail data row (i.e. essentially just one
datapoint) and this is not what you want. Placing the chart however in the
group's header or footer will generate a chart from all the detail rows that
are contained in the current group.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
<hifchan@.yahoo.com> wrote in message
news:1108483860.264648.286130@.c13g2000cwb.googlegroups.com...
>I think I got it by browsing some QA here, simply by putting it in a
> group's header or footer in a table.
>sql

A challenging CUBE related question

Hi,

I have data coming in from our OLTP's view which has the following sales related information:

1) Date of Sale
2) Product Sold
3) Customer to which the Product was sold
4) QTy. sold
5) Total Sale Amount

I am bringing in this information into my "staging area" and from there I am building my Customer, Product, and Time Dimension and obviously my FACT table. The measures in my fact table were TotalSalesand Total QtySold and everything was working fine and I was able to analyze, slice, dice my cube in many ways...

Now the problem:

I also have planning related data available from another OLTP based view which contains the following information:

1) Plan Year
2) Plan Month (using Plan Year and Plan month,I "derived" a date which for any month was the 1st of that month)
3) Planned Product
4) Planned Sale (Amount)
5) Planned Qty (for sale)

You would have noticed that planning is NOT done at "Customer Level" and the planning data is only for product and time level (and that too only upto month level).

After populating my FAct table from the Sales data, I appended the planning related data into my fact table hoping that as long as I do not select any thing in the Customer dimesion and only go as low as the month level on my Time dimension, I will be able to see all of the following (measures) for any/all products:

Planned Sale, Actual Sale, Planned Qty., Actual Qty,

However I am unable to get anything displayed in the Planned Sale and Planned Qty despite applying all of the little knowledge that Ihave so far in the world of BI and making data marts
...

I really hope that my questions and requirement is clear.Can someone please help me get to

the solution.

Many many TIA.I hope I understand you correctly. If I did, I would have thought of doing the following (thinking from OLAP standpoint):

Dimensions:
- Create shared dimension for Time to support Date of Sale and Plan Month, Year
- Create shared dimension for Product

Cubes/facts:
- Create two separate cubes one for Actual and one for Planned using the shared dimensions. The Actual can have the Customer as a Private Dimension (it may help to design the customer also as a shared dimension).
- Create a virtual cube on top of the Actual and Planned.
- Create calculated measures for differentials between Actual and Planned.

Murthy

9 Sales Tax codes...exclude 1...?

How do I exclude 1 sales tax code from a report. I want the other 8 to calculate.
Thanks much!
JulesI got it! I used Select Expert and added this to my formula(s):

{ARV_SalesTaxDetail.TaxCode} <> "IA"

It took that code out so it is no longer on there. Awesome!

Thanks anyway everybody!

Jules