NReco filter cube based on date range

Question

Need to slice cube by date range. After getting the data into the cube how can I pass in a start/end date to limit a slice?

//define full data set
            var allRows = (from c in newContext.MCrmOpportunity
                           orderby c.CloseDate
                           select c)
                          .ToList();

            //define cube pivot
            var cubeData = new PivotData(
                new[] { "CloseDate" },
                new SumAggregatorFactory("Amount"),
                true);

            //process data into cube structure
            cubeData.ProcessData(allRows.AsEnumerable(), new ObjectMember().GetValue);

            var sq = new SliceQuery(cubeData).Where ???????????

            var sc = sq.Execute();
            return sc;

score 0 · Answer 1 · answered Aug 27 '19 at 05:44

Use this SliceQuery.Where(string dimension, Func predicate) overload for this purpose:

DateTime startDt;  // range start
DateTime endDt;  // range end
var sq = new SliceQuery(cubeData).Where("CloseDate", 
            d => (DateTime)d >= startDt && (DateTime)d <= endDt );

(I assume that 'CloseDate' dimension type is DateTime; if not change handling of 'd' accordingly)

NReco filter cube based on date range

1 Answers1