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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. samonsey

    Expanding dimensions takes a long time,

    Does the order in which you expand dimensions matter in Crystal Analysis? It seems that sometimes when I expand my dimensions, it takes CA a long time to display the results, but when I collapse the dimensions (or start over after stopping the app.) and expand them in a different order CA...
  2. samonsey

    Combining Members in a dimension

    Continuation of the above post. I think the answer lies in calculated members, but I don't know which function(s) I should use to create a member that is the roll-up of a set of functions. Thanks, Asa Monsey samonsey@houston.rr.com Tek Systems, Inc. Consultant Visual Basic / SQL Server
  3. samonsey

    Combining Members in a dimension

    MDXer, Thanks for replying. Named sets get me half way to where I want to get. I am using Crystal Analysis as my front end. I created the named set in the cube. When I selected it in CA, it added all of the members that comprised the set to my axis, but it did not create a rollup for them...
  4. samonsey

    Combining Members in a dimension

    I have a simple customer dimension. Some of the customers are grouped together, but none of my data sources have the groupings, and there is only one user that needs the measures aggregated at the parent level. Is there an MDX function that will combine specifed members in one dimension...
  5. samonsey

    Designing Storage and Aggregations

    I have a cube with 29 shared and private dimensions. When I run the design storage wizard, I select MOLAP and move to the create aggregations screen. I select 40% performance improvement and hit start. The graph jumps to around 4% and 126 aggregations, then it slows to a crawl. I left it...
  6. samonsey

    Multiple Hierarchy Best Practice Quesiton

    I have I dimension which has a name and a code for each record. I am wondering if the best practice would be to have the code as a child of the name, or create separate hierarchies for the code and the name, since there is not a one to many relationship, but a one to one relationship between...
  7. samonsey

    Your opinion on star schema dimension

    Typically, this situation should be handled when you load the fact table. You could create a dummy record in the dimension table like "No Code Description". When building the fact table, you do a check to see if the code exists in the dimension table. If it does not, you would...
  8. samonsey

    Use a field as a measure and a dimension

    I have a field "rate" that I need to use as a measure and a dimension. One problem that I have is that I need the measure averaged rather than summed. I think I can accomplish this using the sum/count method, but this requires that the field be designated as measure. However, I...
  9. samonsey

    Data Modelling - Similar Facts

    I have a question relating to modeling the similar facts. We have three types of facts. They are all "transactions", with a common set of core dimensions such as Customer, Contract, Location, Date. In addition, they each have a set of dimensions that are unique depending on the type...
  10. samonsey

    Import XML data into an Access 97 DB

    I have created a simple tool using MSXML 3 and ADO 2.6 to import an XML document into Access 97, create tables based on the hierarchy of the XML data and then populate that table structure. ADO converts the XML document into a hierarchy of nested recordsets that I sort through. This is the...
  11. samonsey

    Import XML into Access 97

    I have created a simple tool using MSXML 3 and ADO 2.6 to import an XML document into Access 97, create tables based on the hierarchy of the XML data and then populate that table structure. ADO converts the XML document into a hierarchy of nested recordsets that I sort through. This is the...
  12. samonsey

    Import XML into Access

    I have created a simple tool using MSXML 3 and ADO 2.6 to import an XML document into Access 97, create tables based on the hierarchy of the XML data and then populate that table structure. ADO converts the XML document into a hierarchy of nested recordsets that I sort through. This is the...
  13. samonsey

    Mail Merge From Crystal? Please Help

    Ken, Sometimes I look for the complicated answer to an easy problem. This just seemed too obvious to work, but it is exactly what I needed. Thanks, Asa Monsey samonsey@houston.rr.com Maxim Group Consultant Visual Basic / SQL Server
  14. samonsey

    Mail Merge From Crystal? Please Help

    Ken, Thanks for the reply, I have gotten many good tips from you just by reading other threads. Can you give me a code sample please? Would it look like this: (double click on the text box) "blah blah blah {adoRecordset.field1} blah blah" TIA, Asa Monsey Maxim Group Consultant...
  15. samonsey

    Mail Merge From Crystal? Please Help

    Does CR 8.5 have the ability to insert data into the midst of large blocks of text (much larger than 255 char), sort of like Word's mail merge feature. I am trying to print contracts that have variable contents. Since not every contract gets every page, simply automating Word from VB will not...
  16. samonsey

    Please Help - Report Data does not refresh

    After reading many related but unhelpful threads, I finally found one that mentioned a call to rptReport.DiscardSavedData I am guessing this is the programmatic equivalent to the File>Save Data with Report option. Since I work exclusively with dsr files in the VB IDE, I was not able to find...
  17. samonsey

    Please Help - Report Data does not refresh

    I have a VB6 app and I am using the CRViewer. I have a report based on a TTX file to which I pass an ADO recordset at runtime using the following code Set crdDatabase = rptReport.Database Set crtTable = crdDatabase.Tables(1) crtTable.SetDataSource Rst, 3...
  18. samonsey

    ADO Recordset appears empty in report

    I have a report (8.5) based on a TTX file to which I pass an ADO recordset using the VB6 code below: Set Rst = oEvent.GetDailyTelecons(datStart) Set rptReport = rptDailyTelecons Set crdDatabase = rptReport.Database Set crtTable =...
  19. samonsey

    Problem displaying Cyrillic fonts

    I have a VB 6 application that functions as a Russian-English glossary. The data is stored in a SQL Server 2000 database using the Latin General collation. The Cyrillic data in the database appears as accented Latin characters on the server, but displays in Cyrillic on the clients in some...

Part and Inventory Search

Back
Top