Hi.,
My requirement is One Physical fact table joined with dimensions ( around 10) in Physical layer .,
In BMM the same physical sholde divided into multiple facts tables ( ex: if total 100 column in one Physical tables, 25 columns in 4 BMM fact tables by grouping related attributes) and joined to same dimensions
In Presentation layer have presentation folder for four fact tables., Report can be created from any of these fact tables. (Measures from more than one fact table).
Issue observed : 1) 2 fact tables I have joined with one common dimension ., when we pull measure columns from two fact table and one dimensional attribute the report is working fine,
2) Pulled a numeric value(no aggregation logic applied in rpd), one measure from one fact table , one measure from another fact table , one dimension attribute . getting cast (null as double precision) in the query and values are displaying as null,
How to resolve cast (null as double precision).
Thanks
Rajagopal R