Search results for query: *

As an add on to what my esteemed colleague reisw said in the previous post... After changing the mapping method to manual for this attribute DON'T change it back to automatic again or you will have the same problem all over again!

Doesn't sound like your DBA is very helpful...isn't database performance tuning his job?? Just my 2 cents...

Check out Tech Note: TN4000-007-0323 "How to retrieve data when null values prevent joins from occuring in MicroStrategy Agent 7.0". I know the tech note sounds dated but the theory sounds viable.

I think what you are going to have to do is actually create 2 separate custom groups - one for each filter in your original custom group. Even though you are asking for subtotals, your original custom group is considered a single entity and cannot be broken down like that. Another possibility...

See TechNote TN5200-7X0-0019 for syntax on ApplySimple. It gives an example (example 2)based on SQL Server using the datediff function (SQL Server) and ApplySimple. I don't know the DB2 function but this note might provide some insight. Other TechNotes of interest: TN5200-7X0-0131...

Have you checked the basics such as the report timeout limit, max number of rows governing? Also, have you properly set up your heterogenous column mapping (a11.LKC_ID = a13.ID)?

Ashmimmalik; A word of caution about Object Manager - Be VERY careful in what you do with that tool. There is no undo button. If you delete an object (such as a report, metric, user, project) it is GONE. There is no way to go back if you make an Oops error. If I can offer one simple...

How does Oracle find which index to use in it's query plan?

That, I'm not sure about. It may be possible, but I'm not an XML/XSL writer. Now that I think of it, there is, possibly, a way so as not to see those other metrics...it's a workaround and not the prettiest, but you might give it a try...Change the metric header and metric value color to the...

Unfortunately, since you have three basic metrics that are being grouped by Month, you are stuck showing all 3 for each month. The only way to create the report you are looking for is to create 5 seperate metrics; Avg Price Month1, Avg Price Month2, Avg Price Month3, Min Price Month 3, Max...

From the standpoint of query performance in an ad-hoc data warehousing environment, can you have too many indices on a table? If I have 100 fields on a table and index 50 of them, will performance become degraded because Oracle has to find which index to use when creating it's query plan...

Often designers end up using a combination snowflake-star approach in which the fields are selectively normalized into seperate tables and at the same time some of these fields are also kept in the lower-level dimension tables (denormed). Much of the design is dependent on update requirements...

I upgraded from 6 to 7.1.2 about 18 months ago. I used the Wizard and had no "appearent" problems. I say "appearent" because while checking how everything came over I noticed a few irregularities. For some reason, a few of my dimensional metrics lost their dimensionality...

Hi all, newbie here. Is it possible to have "too many" indices on a table? In a data warehousing environment, if I have a customer table with 100 fields, and I put an index on 50 of them (assuming of course that an index would be warrented) will the sheer number of indices slow the...

If you are using MicroStrategy, go to the metrics editor/advanced tab and click the checkbox for "Smart Totals". This forces the query engine to work from the base totals instead of simply adding up the column. -Rich

I took the 3 week CBIC class back in version 5 (1998). VERY tough. Fast paced, in-depth, hi-stress. In the end, after what I like to call 3 Weeks of Living Hell, I passed. The tests are not fluff, nor is the project easy. Spent most of my time studying, in class, or in the lab. When I got...