Re: Display no measure for time aggregation?

From: "clir" <christophe.leroquais@xxxxxxxxx>
Date: 2 Mar 2007 00:30:11 -0800

On 2 mar, 01:21, "Jeje" <willg...@xxxxxxxxxxx> wrote:

do you use any other dimension with this measure?

"Chris Le Roquais" <christophe.leroqu...@xxxxxxxxx> wrote in messagenews:45e7467c$0$710$426a74cc@xxxxxxxxxxxxxxx

Hi,

I have daily mesures that I do not want to aggregate (sum or whatever)
along the Time dimension because it does not makes sense.
These values are for example the daily exchange rate of currencies. How a
yerly exchange rate can makes sense???

So When my time hierarchy are at upper levels than the day, I want to
display simply nothing.
I've tried in SSAS to set the aggregation function to 'None' for the
exchange rate but it now display no measure at all! even at the daily
level!!

please help me to know what i've done wrong.
thx

Chris- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -

Yes. Dimension TIME in columns and another one; let's say COUNTRY in
rows

.

References:
- Display no measure for time aggregation?
  - From: Chris Le Roquais

Prev by Date: Optimization with OLAP possible?
Next by Date: RE: PeriodsToDate and (All) member on Time dimension
Previous by thread: Display no measure for time aggregation?
Next by thread: Re: Period-to-Date aggregations and non-empty behaviour
Index(es):
- Date
- Thread

Relevant Pages

[SSAS] Display no measure for time aggregation?
... I have daily mesures that I do not want to aggregate along ... the Time dimension because it does not makes sense. ... These values are for example the daily exchange rate of currencies. ... display simply nothing. ...
(microsoft.public.sqlserver.datawarehouse)
Display no measure for time aggregation?
... I have daily mesures that I do not want to aggregate along ... the Time dimension because it does not makes sense. ... These values are for example the daily exchange rate of currencies. ... display simply nothing. ...
(microsoft.public.sqlserver.olap)