Answer / prem chopra

i will tell you later ok...

Answer / harry

The following document will walk through all steps needed
in setting up drill through from PPES to IWR.

Create 3 Folders in Windows Explorer

1. On C:\ create a folder called C:\DT
2. In C:\DT create another folder called Source ->
C:\DT\Source
3. In C:\DT create another folder called Publish ->
C:\DT\Publish

Copy the sample catalog into the Source folder

4. Copy the 'Great Outdoors Sales Data.cat' into the
C:\DT\Source folder.

Create the IQD to be used as a data source in the model

5. Open the Great Outdoors Sales Data.cat in Impromptu
6. Create a new report in Impromptu and include the
following columns
From Order & Order Details folders
-Order No
-Customer Name
-Order Date
-Closed Date
-Line No
-Product No
-Product
-Order Price
-Qty
-Discount %
-Sale Amount
Save the report - C:\DT\IQD.imr
Save the Report as an IQD as well - C:\DT\IQD.iqd

Create the Impromptu Reports

7. Create new report in Impromptu and include the following
columns
-Order No
-Order Price
Save the report - C:\DT\Source\Measure.imr
8. Create new report in Impromptu and include the following
columns
-Order No
-Qty
Save the report - C:\DT\Source\Cube.imr
9. Close Impromptu

Create the model in Transformer

10. Open PowerPlay Transformer
11. Click File -> New
12. Go through the new model wizard
-Model Name = DrillThrough
-Use IQD as the data source type
-Browse to C:\DT\IQD.iqd
-Make sure 'Run Auto design' is checked and click Finish

Create the Cube

13. Click Edit / Insert PowerCube
-PowerCube Name = DT
-General tab --> Save the cube to C:\DT\DT.mdc
-DrillThrough tab --> Check 'Allow drill through for this
powercube'
Click Add
Browse to C:\DT\Source\Cube.imr
Click OK
14. Right click the Order No measure and select properties.
-DrillThrough tab --> Click Add
Browse to C:\DT\Source\Measure.imr
Click OK
15. Build the Cube by clicking on the Create PowerCubes
button.

Verify the drill through works in client tools
16. Open the DT.mdc in PowerPlay Client
17. When the cube is opened hit the 'Drill Through' button
(+)
18. Select 'Cube' and click OK
19. The Cube.imr report will open up in Impromptu
20. Go back to DT.mdc in PowerPlay Client
21. Drag in the Order No measure
22. Select the Order No measure in the report and hit
the 'Drill Through' button (+)
23. Select 'Measure' and click OK
24. The Measure.imr report will open up in Impromptu

Create a Newsbox in Upfront to Publish the IWR Reports to

25. Login to Upfront and create a newsbox called 'DT' right
in the NewsIndex

Publish the Impromptu Reports to Upfront (IWR)

26. From 'Cognos Server Administration' click 'Report
Publishing' and login.
-Click Tools --> Publish Report Set
-'ReportSet name' = DT
-'IWR Server Report Set Location' = C:\DT\Publish
-'Source Directory' = C:\DT\Source
-'Publish Reports to Upfront Newsbox' = DT
-Click OK
-Verify that the Report Set published successfully.

Run the Reports in Upfront to verify they run OK

27. Log into Upfront and run each of the two IWR Reports,
verify they run without error
-Cube
-Measure


Publish the Cube to Upfront

28. From 'Cognos Server Administration' click 'OLAP Cubes
and Reports' and login.
-Click Insert --> Cube
-General Tab -->
'Name' = DT
'Cube Source' = C:\DT\DT.mdc
-Settings Tab --> Drill Through folder -->
'Impromptu Web Reports' = Enabled
'Impromptu Web Reports drill through newsbox' = //DT
'Impromptu Web Reports server' =
HTTP://<servername>/cognos/cgi-bin/imrap.cgi
-Click Apply
-Click OK
29. Publish the Cube to Upfront
-Select the DT cube in 'PowerPlay Enterprise - Server
Administration'
-Click the 'Publish to Upfront' button
-You will get a notice stating the cube has been
successfully published.

Check the Drill Through in Upfront.

30. Login to Upfront
31. Run the DT.mdc cube
32. Click on the 'Drill Through' button and select 'Cube'
33. The 'Cube' report will run for IWR
34. Click Return
35. Select the 'Order No' measure
36. Click on the 'Drill Through' button and select 'Measure'
37. The 'Measure' report will run for IWR

What is the difference between List and Cross tab? Could some on explain with an example..

2 Answers   Barclays,

---

How can I convert a list report/Cross tab Report in Cognos EP series into a bar chart or pie chart etc.

5 Answers   IBM,

---

what is a query subjects item?

1 Answers   HCL,

---

How to create a dynamic column name in Cognos?

6 Answers   Aditya Birla, Polaris,

---

While running the reports how can we hide totals if the users doesnot requie it?

3 Answers   Satyam,

---

---

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,

---

What is RenderVariable?

5 Answers  

---

how to perform back drill through in cognos 8 what is the use of it

0 Answers  

---

Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.

0 Answers  

---

What do you understand by the term 'model durability'?

0 Answers  

---

we are in a trail to create a crosstab with rolling months as columns,i mean we have a crosstab with LOB as rows and loan amount as measure,coming to the main problem we have to create dynamically changing column in the columns of the crosstab.The requirement is ...we must have two dynamic columns like feb 08 and feb07.For example if current date is feb 28,we have to get the loan amount from 1st of feb to 27 of feb 2008 as feb08 and loan amount from 1st of feb to 27th of feb 2007 as feb07 columns.Please suggest us the possible way....thanks in advance....

1 Answers   IBM,

---

How do we create row level security in cognos8?

3 Answers  

---