That would be heavy in MDX. Create a base measure in your fact and count
during the ETL. Add this base measure to your cube.

T
"SergiuT" <sergiu1001 (AT) hotmail (DOT) com> escreveu na mensagem
news:eOwWSzRsEHA.2948 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Hi,

I am newbie in this business. So, my question could be very simple but for
me it is complicated.
I have a time dimension and a fact table with time field.
My problem is: I need to build a cube that will count all the record where
1.FactTime > DimenssionTime
2.FactTime = DimenssionTime
3.FactTime < DimenssionTime

Unfortunatelly, i am not experienced in OLAP.
This is why it is a real problem for me.

The ETL process is the one through which you construct your fact table. I
assume that you use SQL to transform data from some data source into your
fact table. Then you could use SQL to achieve what you want. Using SQL is
often most economical since MDX is interpreted at run time.



"SergiuT" <sergiu1001 (AT) hotmail (DOT) com> escreveu na mensagem
news:Okl1nXSsEHA.3200 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

How could i do that?

"Tore Johnsen" <naturamo (AT) hotmail (DOT) com> wrote