yes i know that, but i need get all lastchild of each parent.

The cube is based in the tables Fact, [Dim_Store] and [Dim_Elem]. [Fact] table is a measure group, the structure is very simple.

If you need more information please tell me.

Thanks

but i get Cero in all cases.

Store_1 -> 0

Store_3 -> 0

yes, that is an example,

this indicates that in the store_1 there is one element and in the Store_3 one element, but when insert new fact, by example, insert into...

Sorry, more information:

I have :

CREATE TABLE [dbo].[Fact](

[Id_Fact] [int] IDENTITY(1,1) NOT NULL,

[Id_Elem] [int] NULL,

[Id_Store] [int] NULL,

CONSTRAINT [PK_H_Movimientos] PRIMARY KEY CLUSTERED

(

[Id_Mov] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,...

Thanks my friend

That is very interesting, bud i have a problem with "float" data type :unsure: