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

    Opening Report in New Window from Parent URL??

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

    Oracle Stored Procedure in Cognos FM????

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

    Using periodsToDate function with members in different Hierarchies??

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

    Using periodsToDate function with members in different Hierarchies??

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

    Fact & Dimension Relationships Not Working in Transformer Cube

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

    Transformer 10.1 Time Based Partitioning??

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

    Configure Cognos for Integration with SharePoint 2010

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

    Cognos 10.2 Cube Designer Time Dimension!!!

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

    How to use a FOR Loop in Sequence Column??

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

    How to use a FOR Loop in Sequence Column??

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

    How to use a FOR Loop in Sequence Column??

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

    Cognos Bursting With Email??

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

    Count Distinct Values in Excel With COUNTIF?????

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

    Count Distinct Values in Excel With COUNTIF?????

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

    Count Distinct Values in Excel With COUNTIF?????

    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!
  16. sconti11

    Count Distinct Values in Excel With COUNTIF?????

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

    Count Distinct Values in Excel With COUNTIF?????

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

    Count Distinct Values in Excel With COUNTIF?????

    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!
  19. sconti11

    Count Distinct Values in Excel With COUNTIF?????

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

    Count Distinct Values in Excel With COUNTIF?????

    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.

Part and Inventory Search

Back
Top