Redimension 128bit to 64bit

Brendan Broughton
Brendan Broughton Active Partner
Third Anniversary 100 Comments 100 Up Votes 25 Likes
in Platform

Out of interest I'm wondering if it should be possible to dataflow from a 128bit cube (128 Sparse, 64 Dense) to a 64 bit cube...as I can't seem to get it to happen no matter what I try.

 

I'm still working on avoiding the 128bit in the first instance, but if we can't avoid it, once the cube is populated via it's dataflow we will be able to re-dimension this 128bit cube (by removing one dimension) which will allow us to go back to 64bit for future dataflows. The problem at the moment is that we don't seem to be able to flow from a 128 to 64 regardless of the Dflow settings.

 

Thanks

Brendan

Answers

  • Brendan Broughton
    Brendan Broughton Active Partner
    Third Anniversary 100 Comments 100 Up Votes 25 Likes

    For anyone following this thread, my colleague Stephen Kirk discovered that if you apply a time function to the source 128bit it will flow to the 64bit. So we just put a 1 day moving total (for a Day dim'ed cube) and the Dataflow worked.

Categories