February 12, 2014 at 3:52 am
Hi Experts,
We are merging two fact tables with different attributes. For example,
Fact A
CostModelName(Dimension)
Actual_Unit(Measure)
Fact B
IncidentType(Dimension)
Demand_Unit(Measure)
We are creating a tablular cube in which both the fact will be merged. Now merged fact will look like,
CostModelName(Dimension)
IncidentType(Dimension)
Demand_Unit(Measure)
Actual_Unit(Measure)
If user is comparing Actual_Unit value against the Demand_Unit for each CostModelName,
Then internally in the Excel Report cross join will happen on these two tables because tables are not having same level of information, and below result will be coming.
FiscalPeriodCostModelNameDemand_Unit Actual_Unit
8/1/2013CHASSIS 0 9100
8/1/2013 Drive Bay 0 9100
8/1/2013 NetDevice0 9100
8/1/2013 Rack 0 9100
8/1/2013 SAN Controller0 9100
8/1/2013 Server 9100 9100
8/1/2013 SKU 0 9100
all the rows are giving wrong information, as we don’t have any CostModelName in FactB table.
As FactB don’t have CostModelName then, result should have one more row with NULL (or BLANK) CostModelName against FactA value.
FiscalPeriodConfigItemTypeDescDemand_UnitDemand_Unit
8/1/2013 CHASSIS 0
8/1/2013 Drive Bay 0
8/1/2013 NetDevice 0
8/1/2013 Rack 0
8/1/2013 SAN Controller 0
8/1/2013 Server 9100
8/1/2013 SKU 0
8/1/2013 9100
Now, user wants NULL or BLANK always selected but not visible in excel pivot filter .
Please suggest how to implement the scenario.
February 13, 2014 at 6:41 am
debanjan.ray (2/12/2014)
all the rows are giving wrong information, as we don’t have any CostModelName in FactB table.
I'm not sure what you are trying to achieve by simply merging two fact tables. Of course if they have no common dimensional relationship you will have all nulls for one dimension or the other.
debanjan.ray (2/12/2014)
Now, user wants NULL or BLANK always selected but not visible in excel pivot filter .
The only way to control what is shown in an excel filter is to create a named set, although in tabular named sets are not available.
Sorry if I'm not understanding you.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply