Featured post

c# - Usage of Server Side Controls in MVC Frame work -

i using asp.net 4.0 , mvc 2.0 web application. project requiremrnt have use server side control in application not possibl in noraml case. ideally want use adrotator control , datalist control. i saw few samples , references in codepleax mvc controllib howwver found less useful. can tell how utilize theese controls in asp.net application along mvc. note: please provide functionalities related adrotator , datalist controls not equivalent functionalities thanks in advace. mvc pages not use normal .net solution makes use of normal .net components impossible. a normal .net page use event driven solution call different methods service side mvc use actions , view completly different way handle things. also, mvc not use viewstate normal .net controlls require. found article discussing mixing of normal .net , mvc.

olap - How do I add KPI targets to my cube that are at a higher grain to my fact table? -


i have simple star schema 2 dimensions; course , student. fact table enrolment on course. have kpi values set use data in fact table (e.g. percentage of students completed course). working great.

i need add kpi goals though different grain fact table. goals @ course level, should work @ department level, , whatever combination of dimension attributes selected. have numerator , denominators kpi goals want aggregate these when there multiple courses involved - before dividing actual percentage goal.

how can implement this? understanding should have 1 fact table in star schema. in case perhaps store higher grain values in fact table? or create dimension these values in? or alternative solution?

in cases expect kpi measures calculated existing measures in cube, can away idea of fact table changes, , set kpis calculated members in cube or mdx?

your issue complicated kpi granularity being different, yes...but hide kpi measures when such level of granularity being displayed. can implement within calculated measure definition too.

for example, have used isleaf() detect if measure shown @ bottom level, , return blank/null. or can check level number of relevant dimensions.


Comments

Popular posts from this blog

c# - Usage of Server Side Controls in MVC Frame work -

cocoa - Nesting arrays into NSDictionary object (Objective-C) -

ios - Very simple iPhone App crashes on UILabel settext -