Search results for query: *

Debdas, BW is SAP's Data Warehouse product, which integrates tightly with the R/3 product and various modules. Where BW comes up short (IMHO) is from the perspective of an Enterprise Reporting Solution, specifically in the area of Presentation Layer (most notably Report Management and...

bcking, You can in fact edit the sql for a particular report, thus overriding what is generated based on the catalog. Once you do this however, you do lose a lot of functionality within the Report..Query dialog, so make a copy of your imr file!! But basically, from the Report..Query menu...

bobg4u, When you create your actual "model" I don't think you'll want to link those dimensions by using the Item_key -- though this is a common element among these dimensions, you will most certainly get incorrect data as (for example) every shipment of a particular item will get...

Paul, I would love to see some examples of this...specifically within the context of table reads using BAPI....I would appreciate any info, posted here or sent to my email address at pcardoso@pcdevsolutions.com Thanks in advance! Pedro Cardoso A.K.A CanadianTechie[pc2]

Ricardo, Meu português não é muito bom....especially written. I should stick to English.... :-) If you could post up your dataset of 8 records I'll take a peek...I setup some mock data before firing off my previous reply, so I'm not sure why it didn't get you the results you wanted, unless I...

Senhor Pereira, In order to achieve this do the following: For "Number of Reception" measure --------------------------------- - Specify a regular rollup of count - Specify a duplicates rollup of Maximum For "Number of Lines of Reception" measure...

Dave's the man! Your wisdom is much appreciated by everyone....he truly is, (among other things), an Impromptu guru.... {Insert Revered Bow Action Here} Pedro Cardoso A.K.A CanadianTechie[pc2]

Sparked, As a "newbie" to all things Cognos, I find myself at this point in time, commenting on many things that I haven't actually rolled out into production yet -- your point about users struggling with multiple time dimensions is likely quite valid, and learnt through...

Glad to hear you solved your problem. Thank you for letting us know about the Upgrade command with respect to the ppx specifications between V7.0 and V7.1 -- others might run into similar problems. In my case, we are a new install of 7.1, so these version related issues are such that I would...

Xantix, If you only use a defined list of fonts in your reports, you "SHOULD" embed them in your report by utilizing the settings in your PDF server (via Configuration Manager) such that your embedded font list string includes those particular fonts. That way you won't run into...

Sparked, I agree with most of your points sir -- I always like to limit any required manual maintenance (if at all possible). After some further deliberation and musing, allow me to modify then my previous suggestion by instead, in this specific example, assuming that December might not be...

Sparked, The easy answer is to create a calculated column (as I indicated) in Impromptu which is 0 unless the month is December in which case it is the actual column value. It is true that (to my knowledge thus far) this cannot be achieved within the Transformer environment since relative...

Jay, If December is that important to you, and if you have the flexibility in the source/db (or do it in Impromptu), create a calculated column that just includes December sales and you can use that column as a specific measure or as a special dimension.... Pedro Cardoso A.K.A...

Scott, Thanks for the clarification sir! Having now implemented iPlanet 5.1, I will echo your comments, that the product has indeed "matured" compared to version 4.2 under the NDS moniker.. Nice to know that members from the Cognos support team frequent this forum... :-) Pedro...

Jay, You are correct -- time state rollup is for measures -- specifically, the measure in question right now is Inventory Quantity and what you want to do is make that measure a time state rollup SO THAT when you do analyze across the time dimension (and let's say your lowest level in the...

This is indeed not a problem -- however the Cognos Documentation (nor Education) do not cover in any detail the concepts of semi-additive dimensions or snapshot type data (e.g. Monthly Inventory Snapshot data, Daily Backorder Inforation, etc). In a nutshell, this type of dimensional data is not...

I would recommend you create a Database Definition in Impromptu for SQL, and then build a catalog using that database, which as already indicated, you can create a Imp. report over that catalog for the desired data and save it as an IQD for use in PowerPlay. When you are defining the database...

Under the report set location, have you tried specifying the logical drive letter "as if you were running the administration tool locally"? One thing which is "confusing" is that when defining a report set using the Report Administration client from a remote machine, the...

Are you sure your PowerPlay Report was created against a web/remote cube as opposed to a local cube? This is an important distinction as the target/source cube's internal ID identifer in question would not be within the Objectstore/PPES environment... Have you tried using the PowerPlay client...

Take a look at the Upfront Developers Guide. You can create a .utml file that contains xml directives to perform/automate otherwise tedius administrative tasks. You would execute a command like the one below, replacing filename.utml with the filename that you create with the xml -- I have also...