Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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