Asim,by That is exactly the formula I want - but OBIEE won't let me put that syntax in the expression for a logical column. I get the following error: "[nQSError: 27002] Near <by>: Syntax error [nQSError: 26012] ." Thomas, I created a new logical table called "fact_sections" and added in the logical columns for the key and…

No, I need enrolled summed for every row and capacity summed only for unique classes. If I were to query ALL of the data (no filters), grouped by Term/Dept, I would want to see something like this: Term_IDDeptEnrolledCapacity1176ART0301179ART4601179BIOL040 If I were to remove Dept, to just see the numbers at the term…

This will create the two tables I describe and put a few rows in each. In this example date, I would want to see, in OBIEE, the sum total of the capacity of the unique dim_sections (which adds up to 130 in my example) along with the number of enrollments (sum of enrolled column) (which adds up to 4 in my example). I will…

ok, still not working out, let me try to simplify the example: dim_sections - *term_id - *class_id - department - subject - capacity fact_enrollment - *term_id - *student_id - *class_id - enrolled (1/0) (the fact/dim are joined by class_id and term_id, multiple rows in fact_enrollment will exist for one row in…

I am still struggling with this. I am trying to establish this in the setup of the Business Model and maybe thats the wrong place... but thats where I am. I am trying to provide a measure in the repository that SUMS as its normal aggregate function across any of the dimensions, BUT, it must only sum for rows with distinct…

Here are more specifics of the problem. I have a table with one row per "class". In it, I have a column for capacity of that class. So, it is often something between 20 and 200 depending. I have another table with one row per enrollment in classes (so, one person might have many rows in this table... likewise, any one…

Thomas, I think that article is referring to a way to provide different aggregation for different hierarchies. I don't need more than one method. I've tried to place that code into the Expression Builder for a logical column, but it fails with the following message: "[nQSError: 27002] Near <by>: Syntax error [nQSError:…

I can't find any syntax that supports those functions when building a logical column in the Business Model. Closest I can get is this: sum(last("SSA BI Warehouse"."BI Dim Course Sections View"."Class Section Capacity" )) I'm not sure how to add in this part: group by "SSA BI Warehouse"."BI Dim Course Sections View"."Class…

So, if I move a single analysis "Scott Test" from folder "/shared/test" to folder "/shared/reports", I would do a find/replace on "/shared/test/Scott Test" to "/shared/reports/Scott Test". Ok, this makes sense. Now I understand that the catalog is really just a large XML file and all the properties/settings of all the…