Recent content by Z3

With 11 Dims you can probably write a program or an Excel Macro to create views or logical views for you. But I can not help thinking some of these 11 Dims does not help much in reducing cardinality. What I am trying to say is, you probably don't need all the aggregate on all the levels (sparse...

Certainly a good enhancement request to link elements with objects. If this is serving your customer then you can create groups and leverage object group security ACL. Otherwise, You may have to build a bunch of metric prompts name them customer A, customer B, so you can manually choose the...

You can make MicroStrategy handle this easily by creating a bunch of views or logical views. What I don't understand is, why do you need to covert the $sales with TO_CHAR. I am guessing you are trying to avoid the accidental summing. Anyway, there are other functionalities that MicroStrategy...

I am not very sure, but have you tried to edit the template a little? Or, play with a report graph, when you are happy with it, same the template separately? The problem with template is, it's difficult to edit without data, and I don't think the software engineers had invest enough time to make...

Perhaps the "Office" will be a better suit for you?

This should be pretty easy to find out by doing a 5-minute testing. But my guess is there should be a governor setting somewhere.

It's a object oriented world man. You thought you only created new stuff but somehow you have probably changed the component the original project uses, connections, logins, who knows. Anyway, grab a book and find the support number then give them a call - it's probalby the quickest here.

Web Customization? or Custom drillmap?

please contact MicroStrategy Tech Support" what version of software is this?

I guess you are trying to build an OLAP Service report? The specific flow you specify is probably not supported. You may need to open an enhancement request to support.

It's a long story. I'd recommend attending advanced reporting classes. The manual should also help. Basically if you have a "gender" attribute, MicroStrategy would try to automatically figuring out if you mean "employee gender", or "customer gender", so you don't have to define it as two...

if you reduce the size of the data to say one row, does the report come back?

You can make one metric with the definition of 0+the_other_metric. Maybe it kinda solve your problem.

The short answer for you is YES, you can have a dimension table with one attribute and that's very common. You still save space and memory when StreamType presumably as a text string compares to it's ID in number format.

Dan, this is rather easy to write a function to calculate this, and then just create a metric calling this function for a given week.