Cube behavior vs Tableau

tableaucommunity@tableau.com — Wed, 10 Dec 2014 23:34:16 GMT

Hi,

I'm new to Tableau and my background is ssas,I'm trying to do a POC on tableau for below scenerio,Please let me know it is Possible or not.

I have Star Schema with two fact tables each fact has different granularity ,out of 3 dimensions 2 are shared with first fact and second fact and remaining dim(Third) is mapped first fact only .I want to drag these two measure groups in tableau and slice and dice with dimension as we do in ssas .

Mapping

Fact

Dim FactRevenue FactAdjustment

DimCust skCust skCust

DimProd skProd --

DimInterface skinterface skinterface

Overall $ for FactRevenue 4000$

Overall $ for FactAdjustment -1000$

when I slice with Product with above measure groups I would expect below behavior as we observe in ssas cube,Is this possible in Tableau?

factRevenue$ FactAdjustment$

P1 2500 --

P2 1500 --

Total 4000 -1000

Please let me know if I slice with Prod with FactAdjustment measure group value should be empty since that dimProd is not mapped to FactAdjustment Measure group

Is it possible to acheive this in tableau?

I have been working the data blending but results are not as expected,if anyone has work around that would be helpful.

Thanks

Mehra.

Message was edited by: Ran mehra

Content in Tableau Community Forums

Cube behavior vs Tableau