DeclaredSet issue

[not-authorized]

Hi Tomaš, thank you very much for so helpful library!
I'm trying to recreate the following SET and still didn't find how to do it:

SET [Metrics] AS { 
   ( 
     [Metric].[Id].&[1], 
     [Measures].[Bank QLY] 
   ), 
   ( 
     [Metric].[Id].&[1], 
     [Measures].[PG AVG QLY] 
   ), 
   ( 
     [Metric].[Id].&[1], 
     [Measures].[QoQ GR QLY] 
   )
}

I was trying the following code:

metricsTuple = Mdx.Tuple();
model.Metrics.ForEach(m => metricsTuple.With(Mdx.Tuple()
   .With(Mdx.Member("Metric", "Id").WithValue(Convert.ToString(m.Id)))
   .With(Mdx.Member("Measures", GetMeasure(m)))
));
query = query.With(Mdx.DeclaredSet("CustomMetrics").As(metricsTuple));

and what I eventually have got is:

SET [Metrics] AS { 
   (
      { 
        [Metric].[Id].&[1], 
        [Measures].[Bank QLY] 
      }, 
      { 
        [Metric].[Id].&[1], 
        [Measures].[PG AVG QLY] 
      }, 
      { 
        [Metric].[Id].&[1], 
        [Measures].[QoQ GR QLY] 
      }
   )
}

Please advise,
thanks again!

[tomasmaconko]

Hello! Good to know you like the library! Thanks!

We looked at your problem and we see this one is similar to one we had as well. Looks like we mixed SET and TUPLE implementations. So TUPLE implementation is working as SET and vice-versa. What I suggest as quick workarround is to use SET for TUPLE.

I think this bug will be fixed soon, because this one is annoying...

Thanks for feedback!