Hi! I am having problem with the alignment.
I have a grid in a document that does not display consistently in place.
The grid may be aligned with other text objects in Web already but when it's viewed in PDF, the objects are not aligned anymore with respect to the grid columns.
Is there a...
I have created a Logical View to customize outer joins and running totals. Its attributes and metrics run on the report correctly but the problem occurs when I use a filter on the metric that uses the logical view. The logical view statement is repeated with a duplicated identifier name...
Hi! I really cant figure this out. Help Please.
I have data:
Item Class Name
=============================
1 A Name1
1 B Name2
1 C Name3
2 A Name4
2 B Name1
2 C Name6
3 A Name3...
Thanks!
Is it possible to have a running total ignoring the filter?
Product Day Sales Count Running Sales Count
A 8/1/05 10 10
8/2/05 12 22
8/3/05 3 25
B 8/1/05...
wow...it's working!...thank you very much...i wonder if i'm still allowed to make extra question..
I add a column to Table A and the Table B remains the same.
Item Expiration Date
============================
x 8/18/2005
y 9/01/2005
z 9/01/2005
Now we...
Thank you very much amrita...however, it's not yet working. the two "select" works fine separately but when the two is "union-ed", the return takes too long that i didnt wait anymore...but i believe it's getting near.
vongrunt, what I need for now is for dates that exist in table B. But i'm...
Hi. I have an example here for my sql question.
TABLE A:
Item
======
x
y
z
TABLE B:
ITEM DATE COUNT
===========================
x 8/17/05 34
y 8/17/05 4
x 8/18/05 76
y 8/19/05 3
I wanna have a daily inventory of the items...
Select x1.column1 from Table1 x1
where x1.column1 >
(Select x2.column1 from Table x2
where x1.column1 = 5)
============================================
the last clause parameter "x1.column1 = 5"
is the result of a prompt entry.
but is it possible that the the prompt uses the table x2...
Hi! May I ask question on the Prompt/Filter capabilities:
1. I have a prompt that a user can select one of the listed elements. Is it possible to have a filter that an attribute can apply comparison filter between the attribute and selected element?
For example I have a list of levels, (1...
Is it possible to connect to MySQL Database from MicroStrategy? How, please? The MySQL database connection type seems to be not unavailable from the list. Thanks!
Help please with the Running Sum.
I have a "Product" & "Day" Attribute, and "Sales Count" & "Running Sales Count" Metric.
My Current Report displays the following:
Product Day Sales Count Running Sales Count
A 8/1/05 10 10
8/2/05...
Hi. I am a new to MicroStrategy, especially with Project Designing. Hope you bear with me.
I have a fact that has been mapped to many fact tables. Now I'm curious how the MicroStrategy automatically select which table best fit to a certain report. Anyone knows?
Thank you very much.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.