Search results for query: *

Ok..i have trolled the interweb, and have found varying versions of what i am attempting to do. Which is..to pass data item values within a list to a child reports prompts, and to show the child report in a new window...which is basically a window without scrollbars or toolbar!!! Here is what...

I have been working on this project on and off for a few weeks now...and I know I am at my wits end! [dazed] So what I am trying to do is create an Oracle stored procedure that will allow for in parameters and 1 out parameter. The procedure compiles fine, and looks good when running in SQL...

Ok..here is what I figured out...it is not pretty but it does the job. Here is the code: periodsToDate([Crown Margin Analysis - National Cube].[Time Dim].[Fiscal Time Periods].[Fiscal Year], #prompt('pClosingMonth','token','linkMember(lastChild(lastChild([Crown Margin Analysis - National...

I am attempting to create a dynamic YTD column in my crosstab, but the issue I am running into is the fact that for my MDX command periodsToDate I have to pull members from two different hierarchies. Here is the expression I am working with: periodsToDate([Fiscal...

I am experiencing somthing strange with my Transformer 10.1 Cube...at least to me :) So I created a cube using 4 reports from report studio as sources (Time, Distributor, Item, Fact), these reports all point to their respective query subjects within the Framework Package. After creating the...

I have a question for anyone who has built powercubes using Time Based Partitioning...I was wondering if you can still use relative time members accross the partitioned cubes. I mean if you partition based on years, and within your existing Time dimension you are using "This Year" and "Last...

I hope that someone will be able to assist me on this subject, since I have been running in circles lately. So I need to know the best way to integrate Cognos 10.1 with SharePoint 2010. I have read several documents on the subject, including IBM's ( way too simple to work) process...and I am...

I have created a dynamic cube that contains a Time dimension. The time dimension is utilizing 2 data tables which are joined on a key within the Implementation tab of the time dimension. After building the levels within the time dimension, I loaded the members, and everything looks great...

Ok...I think I am getting closer to a solution..to add more context to this already confusing issue...the original data that I am working with contains 12 columns of Amt data, one column for each month of a year, and the same number of columns for Units. So the columns are like this: Amt_01 |...

Ok...here is a sample of what I am talking about...hopefully it comes out ok: Amt | Unit | ProjectID | Year | 30 | 5 | 213 | 2005 | 789 | 15 | 213 | 2005 | 435 | 53 | 214 | 2005 | 30 | 9 | 214 | 2005 | 30 | 91 | 214 | 2005 |...

My title is a mouthful..i know. But please bear with me. I am trying to figure out the best way to go about creating a column that needs to be created based on the number of rows in another column. Here is what I mean..I have a column titled YearID, and there can be between 1-12 rows for each...

I am new to bursting..and my challenge is to burst a report to a list of Relationship Managers, and the report should only show their customers. So I have the main query which is grouped by the RM and is used as a Section. I then have a seperate query to hold the RM's email address..which will...

Yea...this sounds very manual. I get what you mean, but I guess i am looking to automate this more efficiently. So the pivot table does provide me a unique list of servers per month, but now I need to create a formula that will count those and place them in my first tab which is the summary...

Yea...I am looking...and unlike you I do not have "Programmer Eyes". I inserted a pivot table using ColA (Months) and ColB (Server Names), and then I used ColA as the Column fields and ColB I moved to the Values so as to get a count. It counts the instances, but does not remove duplicates. So...

Yea...I tried the pivot table...but that alone will not give me the unique counts I am looking for. Thanks for your patience with me!

Forget that...my calculation will NOT work! The piece of the formula that should check for duplicates (IF(FREQUENCY(MATCH(PrtNbr,PrtNbr,0),MATCH(PrtNbr,PrtNbr,0))>0,1)) is not correct. If I apply the sum like this: SUM(IF(FREQUENCY(MATCH(PrtNbr,PrtNbr,0),MATCH(PrtNbr,PrtNbr,0))>0,1)) then I...

Ok...here is what I came up with, and it seems to work when I am not employing a dynamic Name Range: =SUM(COUNTIF(Servers!C3:C500,"Jan")) - IF(FREQUENCY(MATCH(PrtNbr,PrtNbr,0),MATCH(PrtNbr,PrtNbr,0))>0,1) But I need the range "PrtNbr" to be dynamic since I am populating the data from an access...

Here is what I came up with...yet it is still counting the duplicate records: =IF(FREQUENCY(MATCH(PrtNbr,PrtNbr,0),MATCH(PrtNbr,PrtNbr,0))>0,COUNTIF(Servers!C3:C500,"Jan")) I am not familiar with the FREQUENCY or MATCH function,,,so any assistance will be helpful!

ok...I was able to get a count..but this leads me to two questions: 1. How to then incorporate the additional IF statement to test for the month in ColA. (i.e. COUNTIF(A3:A400,"Jan")) 2. How to dynamically expand the range for my named range ("PrtNbr"), because I am bringing in data from...

I placed the formula on the first tab, which is my summary tab. That is why the formula refers to the tab "Servers"...to be exact I have the formula in cell D20 on my Summary tab worksheet.