P
Porfirio Fuentes Martínez
I have seen here some conversations regardingn the MSDN example for Adding a
Measure for an OLAP cube, but in all the cases the examples are related to
add a measure based in data that already exists in the table
MS_CUBE_ASSN_FACT, but what happens if I need to create a measure based in a
value that is not based in the data of this table, by example I would like
to create measures based in the fields related to earned value: BWCS, BCWP,
ACWP.
So my questions are:
1.- I think I need to add these fields to the MS_CUBE_ASSN_FACT table, but,
where are these stored???
2.- if I do this addition what I need to do for this data to be updated
every time I update the cube??
3.- how this happens with the data that is by default in the
MS_CUBE_ASSN_FACT table??
TIA
Porfirio Fuentes
Measure for an OLAP cube, but in all the cases the examples are related to
add a measure based in data that already exists in the table
MS_CUBE_ASSN_FACT, but what happens if I need to create a measure based in a
value that is not based in the data of this table, by example I would like
to create measures based in the fields related to earned value: BWCS, BCWP,
ACWP.
So my questions are:
1.- I think I need to add these fields to the MS_CUBE_ASSN_FACT table, but,
where are these stored???
2.- if I do this addition what I need to do for this data to be updated
every time I update the cube??
3.- how this happens with the data that is by default in the
MS_CUBE_ASSN_FACT table??
TIA
Porfirio Fuentes