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

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

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

I am in need of counting distinct text values within a column where the 2nd column is equal to a value. Example: ColA has values such as Jan, Feb, Mar, etc ColB has values such as FGG1212, GGF2233, etc ColB will have repeating values. I need to count ColB where ColA equals "Jan", but they...

I have not tried this before, and from what I have read it should be possible, but I am missing the beginning piece of this flow. I need assistance with correct approach for passing a value into a user defined variable within a ssis package. If I have a Stored Procedure that contains the...

I am working on a report in 8.4 that requires I display the values of a prompt based on selections made on the prompt page. So this report uses a prompt page as well as prompts on the report page. The prompt that I need to change is using static values. I noticed that there is an option to...

The following code is what I am using to hide/show: Javascript: jQuery('#slickbox3242').hide(); jQuery('#slickbox3243').hide(); jQuery('#slickbox3244').hide(); jQuery.fn.fadeToggle = function(speed, easing, callback) { return this.animate({opacity: 'toggle'}, speed, easing, callback)...

I have been trying to create a simple conditional format on a column chart so that those columns that fall under the benchmark goal (which is the 2nd value in the chart, and is a Line type). Here is the expression I was using: =iif((Fields!Score.Value < Fields!BenchGoal.Value), "Red", "Black")...

I am in need of figuring out the correct way to right a query for a report dataset! The requirement is a matrix or table that has a parent group of Months, then a child group of weeks of that month, and then student scores. The data shows scores by a standard date...so you could have a score...

oK...I may be missing something here, but I can not seem to figure out how to get the Category groups of a Line Chart to reflect certain number of months (i.e Sep - May). This would be consistent for each chart. I have a dataset that does carry dates, but as soon as I apply a where clause to...

I ma building some reports that contain both Line Charts as well as 100% Stacked Bar Charts. So my question is, can I apply conditional formatting to the lines and bars, so that when the value falls under a benchmark value it turns red. I have not found how this can be done yet....any insight...

I have just been asked by my business if we can initiate my SSIS package ON DEMAND. Basically be able to update the records (which is done within the ETL of the SSIS package) whenever a user wants to. Without getting into the logistics of this, I am trying to figure out how to create a simple...

Can someone explain what is happening in the code seen below?..it is part of a whole of functions used to slide div tags up and down. function startslide(objname){ obj[objname] = document.getElementById(objname); endHeight[objname] = parseInt(obj[objname].style.height)...

I have been searching this site as well as others to solve this problem. I need to set a parameters default value to the resultset of a dataset within the reports. So here is the scenario: I have a report that uses a parameter called @Franchise, this is a unique id(FranchiseID) of the user...