Search results for query: *

If anyone who is interested, I went to the metadata DB and ran the following query: select OBJECT_NAME,ABBREVIATION from DSSMDOBJINFO A inner join DSSMDUSRACCT B on A.OBJECT_ID=B.OBJECT_ID where OBJECT_TYPE =34 and SUBTYPE=8704

Chael I don't see a command for that in command manger. Everything in command managerrequires to specify a user. OV

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...

Never mind. I did it, using a relationship filter. OV

...the sales in which salesperson 1 participates; in my example that would be 100+150+120+300=670 In SQL: Select sum(Sales) from Fact_Sales A where exists (Select * from Fact_Sales B where A.Job=B.Job and Salesperson=1) How do I do this? We are in version 7.2.3...

I guess, I should ask another question here: Besides the error log file within the DTS package, is there another way to log the errors? That may give me a little more information that I can use.

dyarwood, It seems that while the database is getting bigger, the problem happens more frequently. However, the problem ocurrs at different steps, some of which are not transfering any data. OV

Rasanders, thanks for the sugestion. However, after looking at the logs, it appears that backups were done way before DTS package started to execute. OV

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...

Yes, It will allow you to hardcode SQL.

thanks asudevil. It appears that changing the session timeout fixed the problem.

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

Yes they are attributes, and the problem most likely is related to the hierarchy in that picture. I seems like you may have some compound keys. I am not sure that you can do this, but can you remove Carrier Key, Account Key and Group Key from the hierarchy? If you can, update schema and see...

Are the choices that you mention attributes or Hierarchies? I would start by looking at the drill path of the report to make sure that the same hierarchy or attribute is not entered twice. OV

Did you get this problem resolved?