Search results for query: *

I GREATLY appreciate your concise answers. Just the bullets I was looking for. What concerns me is IMHO the business requirements require, at the minimum, a separate data store in order to facilitate user requirements other than the tool which is being viewed as the final and only data store...

Thanks -- the rationale behind it has nothing to do with security. It is (IMHO) an over-zealous outlook on an analytical tool which supplies fantastic data associations, however, the data cannot be extracted except in very small and specific queries, unless viewed via the tool's UI (the...

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

It worked GREAT!! Very ingenious solutions. Thanks you very much guys! Sincerely, Mike Z

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

Thank you VERY much! It worked. I moved all report and page headers into the Group header section, and was thus able to create a new page for each distinct group. I was even able to put the Details section of a subreport into a group header section. This is a great forum, and I very much...

Hi Sunny, No, sorry that does not do it. Each report has a couple of report headers (formulas diplaying account Name, date, etc) and a couple of page neaders. The Group header is just displaying the new value of the group. Shall I try putting the report headers inside the Group header...

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

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