Hi Mike, Sorry for the delay. I was going to see if someone else replied first.
On Sun, May 4, 2008 at 10:40 AM, Mike Yard <[EMAIL PROTECTED]> wrote: > Hello, > I have two questions about reports i AW. Hope you can help me out here. > Q1) I'm trying to figure out if it's at all possible to show a > stringvalue where you'd normally aggregate. > For example: > The following report has a row_dimension_name with persons and a > column_dimension_name with information about the person. > > Sex Beard Date of Birth > -------------| ------- |--------- | ----------------- > Person1 | Male | Yes | xxxx-xx-xx > Person2 | Male | No | xxxx-xx-xx > Person3 | Male | No | xxxx-xx-xx > > Is this possible? Well, I've never done it. The issue that comes to mind is that you don't know that you're working with a single row from the fact table. Thus if your current dimension is comprised of 10 or so fact rows how would you know what to return? You might try using a type of max. It wouldn't insure that all rows for that dimension are identical but it may return the value as you want. Try this in your fact: aggregate :gender, :type => 'max' You could make mods to the code to return the first of the list but it would have the same downside as max would. > Q2) Also, is it possible to show just 2 row_dimension names without > displaying a column_dimension_name? > E.g. > > Person 1 | address_of_person_1 > Person 2 | address_of_person_2 We sort of did this. First, the rendering code needs two dimensions. The same is true for the cube engine. I know an empty dimension is on the wish list but I don't see that happening soon. What you could try is fake it out. We made a dimension called EmptyDimension. We created a table just like for any other dimension with an id and name. It had one row, which was the string we wanted displayed on the form. We called our statistics. Then you add this dimension to your fact like any other dimension and give all fact rows the foreign key to the empty dimension table. Not as cool as it could be but it worked for us. Cheers, Marty _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
