ASP...

Let say I pass values from first page to second page using a form, how can I
retain the value in the corresponding area (text, radio button, texarea, dro
p
down menu)in the first page when i press the back button on the second page.
--
regards seowhuaYou've posted to the wrong newsgroup - this is for SQL Server, not ASP
programming. I'd try posting your question to one of the
microsoft.public.dotnet.framework.aspnet.* newsgroups. (Ditto for your
"ASP Calendar..." post too.)
*mike hodgson*
blog: http://sqlnerd.blogspot.com
seowhua wrote:

>Let say I pass values from first page to second page using a form, how can
I
>retain the value in the corresponding area (text, radio button, texarea, dr
op
>down menu)in the first page when i press the back button on the second page
.
>sql

AS2005 MDX-Question (Grouping while ignoring intermediate level)

Hi,

I'm quite new to MDX and try to solve the following problem: given is a dimension having the following hierarchy:

Business Unit A
Sales Area 1Customer XCustomer YCustomer ZSales Area 2Customer VCustomer WCustomer X
Business Unit BSales Area 3......

Now I need the sum of each business units' revenues grouped by customers. In the above example the result should look like:
Business Unit A

Customer VCustomer WCustomer X (sum of Sales Area 1 and Sales Area 2)
Customer YCustomer ZSales Area 2Business Unit BCustomer ...
...
Is this possible with MDX?

Thanx for any help and kind regards,
Gerald

Gerald, try this:

{GENERATE({[OrgDimName].[HierarchyName].[BusinessUnitLevelName].MEMBERS},

{[OrgDimName].[HierarchyName].CURRENTMEMBER,

DESCENDANTS([OrgDimName].[HierarchyName].CURRENTMEMBER,

[OrgDimName].[HierarchyName].[CustomerLevelName], SELF)})} ON ROWS

If you replace SELF with SELF_AND_BEFORE you will also get the Sales Area sub-totals.

HTH

Philip Taylor

|||Philip, thank you for your answer.
What I forgot to mention (and is quite important, I think) is that the dimension is a parent-child-dimension:
business units are on [Level 04]|||

Gerald,

Can you explain the meaning of revenue(X1) and revenue(X2) in relation to Customer X please.

Also you might want to create a level naming template ( see http://msdn2.microsoft.com/en-us/library/ms167115(d=ide).aspx and there is an equivalent in AS2000) which I think makes it easier to navigate your org structure and write MDX queries.

Regards

Philip

|||Philip,

the formula in brackets is just thought as an explanation of how the revenue should be calculated. So the revenue for business unit 1 should be the sum of the revenues of customers V, W, X, Y and Z where customer X appears twice, once with revenue value X1 and once with revenue value X2. In other words "revenue(n)" means the revenue value of customer n stored in the facts. I just see that I've made a typo at customer W: of course it should be revenue(W).

Anyway - I have just had a talk with the guy responsible for the cube design and it looks like we will make a second cube which is optimized for reporting. In this case I'll have a dimension which gives me the desired structure directly and I won't have any problems getting the results our customer would like to see.

thanx and kind regards,
Gerald

Area Chart - urgent Help

I have an Area Chart with four different values plotted on it, as 25th
Percentile, Median value, 75th Percentile and the Customer data.
Now that with SP1, we can specify FILL color, it has become very useful on
this Area chart. (mind you this is Simple Area chart).
However, in certain cases where the customer data completely falls above say
25th Percentile, the whole FILL area of 25th Percentile is overlapped with
the Customer data (and overtaken by Customer FIll color)
SO, I used for customer data, the background color as <Transparent>.
It works absolutely perfect (and as per the color I specify and the border)
in the LAYOUT window, but unfortunately, in the Preview Window it just messes
up..! (and so does when I actually deploy this chart on the Report Server)
I do not understand, why is the display in <Preview Window> any different
from the <Layout window> '
Pls. guide.Please read my responses on your other thread.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:64445861-60E1-407D-839F-7BA0F16BDCD4@.microsoft.com...
> I have an Area Chart with four different values plotted on it, as 25th
> Percentile, Median value, 75th Percentile and the Customer data.
> Now that with SP1, we can specify FILL color, it has become very useful on
> this Area chart. (mind you this is Simple Area chart).
> However, in certain cases where the customer data completely falls above
say
> 25th Percentile, the whole FILL area of 25th Percentile is overlapped with
> the Customer data (and overtaken by Customer FIll color)
> SO, I used for customer data, the background color as <Transparent>.
> It works absolutely perfect (and as per the color I specify and the
border)
> in the LAYOUT window, but unfortunately, in the Preview Window it just
messes
> up..! (and so does when I actually deploy this chart on the Report Server)
> I do not understand, why is the display in <Preview Window> any different
> from the <Layout window> '
> Pls. guide.

Area Chart - Is there a bug?

I have an Area Chart with four different values plotted on it, as 25th
Percentile, Median value, 75th Percentile and the Customer data.
Now that with SP1, we can specify FILL color, it has become very useful on
this Area chart. (mind you this is Simple Area chart).
However, in certain cases where the customer data completely falls above say
25th Percentile, the whole FILL area of 25th Percentile is overlapped with
the Customer data (and overtaken by Customer FIll color)
SO, I used for customer data, the background color as <Transparent>.
While chossing color and borders etc, the image that is brought up in the
<Layout> window matches with what selection I've made. However, in the
<Preview> window, the Chart takes GREEN fill-color (mind you, I've chosen
Transaparent color) and thus washes away the area for 25th Percentile
(considering the situation wher the customer data values fall above the 25th
Percentile)
jfyi: The palette I've chosen in this case is <Default> However, I've
already tried with all supported palettes..! They all result into some FILL
color for my customer data.
I do not understand, why is the display in <Preview Window> any different
from the <Layout window> '
The other strategy I've tried is, to plot Customer data as a solid black
line, but seems that feature is not supported (<Plot data as a line>), as
well.
Pls. guide.Several comments:
* "why is the display in <Preview Window> any different from the <Layout
window>"?
The layout window will not execute your queries to retrieve the datasets. It
will use random data to give you an approximation of how the chart will look
at runtime. In addition in layout mode expressions cannot be executed (e.g.
the expression result might depend on the dataset).
* Black line:
You need to use an expression (i.e. ="Black") in this particular case. Due
to a bug, the report designer does not write a constant chart color of Black
into the RDL-file.
* Combining area charts with line charts by using a "Transparent" fill
color:
Based on the RDL specification, Transparent is not a valid color. Therefore
you cannot use Transparent right now for the color property. Please try this
for now:
Color: e.g. White
Gradient: TopBottom
EndColor: ="Transparent"
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kam" <Kam@.discussions.microsoft.com> wrote in message
news:A8AF6608-E6B1-4B44-851E-3F43E0FBCD62@.microsoft.com...
> I have an Area Chart with four different values plotted on it, as 25th
> Percentile, Median value, 75th Percentile and the Customer data.
> Now that with SP1, we can specify FILL color, it has become very useful on
> this Area chart. (mind you this is Simple Area chart).
> However, in certain cases where the customer data completely falls above
say
> 25th Percentile, the whole FILL area of 25th Percentile is overlapped with
> the Customer data (and overtaken by Customer FIll color)
> SO, I used for customer data, the background color as <Transparent>.
> While chossing color and borders etc, the image that is brought up in the
> <Layout> window matches with what selection I've made. However, in the
> <Preview> window, the Chart takes GREEN fill-color (mind you, I've chosen
> Transaparent color) and thus washes away the area for 25th Percentile
> (considering the situation wher the customer data values fall above the
25th
> Percentile)
> jfyi: The palette I've chosen in this case is <Default> However, I've
> already tried with all supported palettes..! They all result into some
FILL
> color for my customer data.
> I do not understand, why is the display in <Preview Window> any different
> from the <Layout window> '
> The other strategy I've tried is, to plot Customer data as a solid black
> line, but seems that feature is not supported (<Plot data as a line>), as
> well.
> Pls. guide.
>