hello,
can anyone tell me how to model flags in star schema or snowflake?
is there any tip for this?
I've got source table in pharmaceutical system, e.g.: Product table with
fields:
ProdId, ProdName, Flg_Narcotic, Flg_Psychotroph
and data:
1, SomeDrug2, 1, 1
2, SomeDrug, 1, 0
3, SomeDr...
more >>
>
> ±ÏÒµÖ®ºóÀ´µ½Õâ¸ö³ÇÊÐÒѾÓпìÁ½ÄêµÄʱ¼äÁË£¬±ÏÒµµÄʱºòÔø×ö¹ýÍÆÏúÔ±£¬À
> ¹ý
> ÒµÎñ
> £¬×îÉîÇеĸÐÊܾÍÊÇÈËÇéµÄ®µÃÏóÒ»±°×¿ªË®¡£
>
> ºóÀ´½øÁËÒ»¼ÒÍâ×ÊÆóÒµ£¬ÏÖÔÚÒѾ³ÉÁËÈËÁ¦×ÊÔ´²¿µÄÒ»¸öС¾Àí£¬ÔÚ±ðÈ˵ÄÑÛ
> Àï
> Ò²Ëã
> Êǰ×ÁìÒ»×åÁ˰ɡ£
>
>
> ¾¡¹ÜÊÇÉú»îÁË¿ìÁ½Äê...
more >>
I would like to order the result of a MDX command to a cube by one of
the measures. Is it possible?
When I´m creating a dimension I can specify that I want to order a
dimension by name, key or a property.
But my boss would like to see the the customer who sold more in the last
month. So It´...
more >>