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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PowerPlay save as Excel leaves 'group' column blank

Status
Not open for further replies.
GoldFoxtrot

GoldFoxtrot

MIS
Feb 20, 2004
14
US
I used PowerPlay for Windows to create a crosstab report with for example, prodct line/product across all measures. The prodcct line/product is a defined 'subset' from the All Product dimension. I saved the report as 'Microsoft Excel Workbook' for a user who does not have PowerPlay. My problem is that in the Excel file, the column one, 'Product line' has data only for the first row of its many products rows. How can I 'duplicate' the 'Product line' values in this "one to many" situation? Your help is very much appreciated. Thanks in advance. BTW, this questions applies to any A,B across C type of reports.
David Liang
 
Status
Not open for further replies.

Similar threads

NileshDhande
  • Locked
  • Question
Can I use web api as data source to cognos?
Replies
0
Views
127
NileshDhande
NileshDhande
donape
  • Locked
  • Question
TM1 Cafe Reports in Excel -Which View?
Replies
0
Views
99
donape
donape
damzi
  • Locked
  • Question
using 2 measures as one measure in cognos transformer
Replies
0
Views
52
damzi
damzi
kvenkata
  • Locked
  • Question
Forcing subquery in main query filter as optional even when data exists
Replies
0
Views
68
kvenkata
kvenkata
vignesvar
  • Locked
  • Question
Report studio able to create a filter for particular column alone?
Replies
0
Views
39
vignesvar
vignesvar

Part and Inventory Search

Sponsor

Back
Top