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 bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Why an open data store ? - HELP!
Hello, I am a BI consultant on a new project which exists to integrate data from outside enterprises as well as providing the data to users for analytic apps. I find it incredible, but I am in the postion of having to justify why we need to include in our architecture not just a data...- mzimmpa
- Thread
- Replies: 6
- Forum: Data Warehousing/Big Data
-
Orphaned Summary Line
Hello, Once again I turn to the experts! I have a group with a couple of Group headers, a details section and a Summary (of one field) in the Group footer. Problem is, all the detail records print on the first page, but then the Summary gets printed on the final page by itself. I want to...- mzimmpa
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
New report on new group value
Hello all: I have a source table which might include 1, or up to 7 different values in a particular field, call it field X. I have to report on all the rows in the table, grouped by X. When X changes, I need a whole new report, including the Report header and footer, for each X, and...- mzimmpa
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Weighted Average in cube
Hello all: New to mdx. I am having a terrible time creating MDX query to resolve the weighted average. I have an "Officer" dimension with following levels CREATE TABLE [dbo].[Officer_Dim] ( [Holding_Company] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [Affiliate]...
