Search results for query: *

Does anyone know how to generate a list of the users in the system, with their names and logins. Thanks OV

I have several date fields in my tables that do not have a value. For example a shipment date does not have a value until something is shipped. Date fields are defines as integers in the fact tables. However, allowing them to be null, causes problems with aggregate tables (These date fields...

I have the following problem. For every job in the database we can have one or more salesperson. Example: Job Salesperson Sales 1 1 $100 1 2 $150 1 3 $120 2 1 $300 Total sales of salesperson 1 in this case would be $100+$300=$400...

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...

Hi Everybody, I am having problems with a DTS package that runs nightly. It is always the same error but it happens at different steps of the process and at different times. It happens on average of once or twice a week. The rest of the time it runs fine. Some of the steps where it has failed...

Hi, One of the users is having trouble exporting to PDF. Some of the reports will export fine but some others will not. The user does not get an error; nothing comes up when he clicks on the "Export to PDF" button. My initial thought was to check the limit on the number of cells allowed to be...

Does anyone know how to create a report in Enterprise Manager that gives all the reports not used in a time period? thanks, OV

How do I find which users that fall under a security role. Thanks, OV

I am planning to take the following two classes: MicroStrategy 7i Engine Essentials MicroStrategy 7i: Engine Tuning and VLDB Properties I believe that they were introduced recently. Has anyone taken them? If so, can you comment on the quality of the class? Thanks, OV

I am having problems with images in reports with thresholds. Users can not see the image, just "X Threshold Image" Images are located in a shared folder in the network where documents are also located and users can see these without a problem. Basically I followed document...

Microstrategy version 7.2.3. I have set a default drill map under project configuration/drilling. Yet, if I build a new report, I still need to associate it to a drill map because no drill map is associated by default. In version 7.2.0 that was done by default. Any ideas why? thanks, OV

Hi everybody, I am having some problems with the reports being executed against the warehouse instead of the cache. This is what I did: I created a user that has no security filter. The user has full control over the reports that he is running. Then I set up the following: Under Project...

Hi, I have the following problem: Attributes A and B are both positioned as "Page by" in a report. I also total by those two attributes. (subtotals\advanced\accross level\ and then select A and B) However, if I select "Total" on attribute A (the first Page by attribute)...

I am unable to delete the drill paths even though I have removed all the associations. When I try to delete, it says that there are dependant objects but then it searches and it can not find any dependants. I also search for hidden objects and I have restarted the server in order to clean up the...

Hi, Is there a way to display to a user the security filter applied in the report? (Version 7.2.1) thanks, OV

Has anyone had any experince with exporting to Lotus 123? I can do it as a two step process: First export to CSV file and then to Lotus. However, formating it is not very good and users get confused of where they saved the report or how to open a CSV file etc. Is there a way to automate it as a...

Is there a way to change the default minimum password length in standard authentication? OV

Hi I have the following scenario: User Group B is a member group of User Group A. In A, security should be less restrictive then in B. For example, users in A can see everything within a country while users in B can see only their state. The problem is that those two filters are combined by an...

Hi, I have the following situation. In a project, I have two completely unrelated fact tables. Different users can see different slices of data from each table. The only way I believe I can controll that is by creating security filters. The problem is that if I can have only one security filter...