Hi, I'm having trouble to filter a Customer Set by the date of his first buy(First Activity). I've tried this two ways: 1. Returns all customers, even with FirstActivity Null SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { Filter( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ).Count > 2 ) } ON 1 FROM [SCA] 2. Return customers that FirstActivity is not null but is outside the Year specified(In this case 2012). SELECT { [Measures].[Valor Item], [Measures].[First Activity] } ON 0, { NonEmpty( { [CLIENTE].[Cliente].[Cliente].Members }, ( [Measures].[First Activity], [Time].[Year].&[2012-01-01T00:00:00] ) ) } ON 1 FROM [SCA] Any …

Member Avatar
Member Avatar
+0 forum 1

Hi, I'm starting with BI, Analysis Services, Cubes and ADOMD.NET. I searched a lot and was able to make some demos, but the performance is not good. What I'm trying to do it's a Dimension tree view explorer. Currently I have the following code: [CODE] CubeDef cube = conn.Cubes.Find( "SCA" ); Dimension dim = cube.Dimensions.Find( "CLIENTE" ); Hierarchy hrc = dim.Hierarchies.Find( "LOCAL" ); MemberCollection estados = hrc.Levels.Find( "EST" ).GetMembers(); StringBuilder sb = new StringBuilder(); // Loop first level foreach ( Member e in estados ) { sb.AppendFormat( @"<div class=""estado""><span class=""titulo"">{0}</span><div class=""cidades"">", e.Caption ); MemberCollection cidades = e.GetChildren(); // Loop second …

Member Avatar
Member Avatar
+0 forum 1

Attention marketing professionals: Sending cute toys along with press releases is a good way to get me to notice them. I received a package today from Actuate, which makes RIA and business intelligence tools. In addition to news about BIRT-based Actuate 10, which I’ll get to in a minute, the package contained a small Lego robotic space-man kit. I love Legos, and so does my 11-year-old son. He and I have spent countless hours constructing vehicles and small buildings with the small plastic geometric building blocks. A half-dozen fully-constructed space ships and terrestrial vehicles currently adorn Nick’s bedroom, embarking frequently …

Member Avatar
Member Avatar
+0 forum 3

The End.