When you use a lookup table in cube, you must specify the pk-fk, right? That pk will be use to derive the “derived” columns;
On 4/22/15, 5:52 PM, "dong wang" <[email protected]> wrote: >then how to specify its PK? > >2015-04-22 17:41 GMT+08:00 Shi, Shaofeng <[email protected]>: > >> The derived columns are ³derived² from its pk, so only the pk will be >> aggregated during cube building; >> >> On 4/21/15, 6:39 PM, "dong wang" <[email protected]> wrote: >> >> >another question is that why I cannot see the derived columns such as >> >"city_name" in the "SELECT" part of the sql for the cube description? >> > >> >2015-04-21 18:22 GMT+08:00 dong wang <[email protected]>: >> > >> >> is it correct that the column specified in the first input box(click >> >>"new >> >> derivved" button) is the basic column(such as city_id), and the >>latter >> >>ones >> >> are the derived columns for the column in the first input box? or >>how to >> >> specify which column is the basic column to be derived? >> >> >> >>
