Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Select ALL rows from table1, & if exists, associated rows from table2
Unfortunately, I need to twist it's arm.- mdl333
- Post #3
- Forum: MicroStrategy, Inc. solutions
-
Select ALL rows from table1, & if exists, associated rows from table2
I need to "Select ALL rows from table1, & if exists, associated rows from table2". My problem is similar to the question: "Show me all customers and associated orders, including customers with no orders". Some rows will have customer details but no order details. My situation and background...- mdl333
- Thread
- Replies: 2
- Forum: MicroStrategy, Inc. solutions
-
Display Current Date on Report Grid?
I don't have permissions to create attributes. I was aware of the print options, but users actually wanted the run date on the grid. Anyway, the pass-through function worked. Here it is for Red Brick: ApplyAgg("Max(current_date)", 0) {~ } All I needed to do was change the data type to Date...- mdl333
- Post #3
- Forum: MicroStrategy, Inc. solutions
-
Display Current Date on Report Grid?
How do I display the current date on a report grid output? Quite simply, I want the current date to report on each row returned, no matter what the report results are. Users have been requesting this for various reasons. I'd like to accomplish this without the creation of an attribute...- mdl333
- Thread
- Replies: 4
- Forum: MicroStrategy, Inc. solutions
-
MSTR 7.1.3 -> 7.2.2 Security Filters
No, but the fact that it was "broken" prevented us from using security filters before. I was not aware that this was supposedly fixed, so I'll try them tomorrow and see if they work as intended. Mark- mdl333
- Post #2
- Forum: MicroStrategy, Inc. solutions
