I am having metric fields along with some non metric fields in fact tables(All the fields has to be present in fact table only). Is it possible to group all non aggregated fields and aggregated fields in the same fact tables. Please advise.
Just go for alias and do it.
Just do it and post for any issues
mark if helps
OBIEE, Endeca and ODI: Fact and Dimension from single source Table
Thanks for your inputs..
If helps mark and close it, that helps others too