Access Manager with powerplay connect integration 2

[RicardoPereira]

Hello,

I'am using sql server analisys services to create cubes.
Then i use the powerplay connect to create an mdc file.
My question in:
How do i integrate the user authentication (Access Manager) with powerplay connect generated cubes ?

Thanks

Ricardo Pereira

 

[flex13]

Lengthy, but here are the steps ...

A. Start with Configuration Manager:
A1. Launch Start --> Programs --> Cognos EP Series 7 --> Tools --> Configuration Manager
A2. In left pane, expand MyServerName --> Services --> OLAP Data Access.
A3. Select 3rd Party OLAP Server.
A4. In the right pane, click the 0 to the right of Microsoft OLAP Service.
A5. Change the 0 to a 1. [This will enable you to create connections to MS SQL Server cubes.]
A6. Click on OLAP Data Access then Actions --> Apply Selection
A7. Say Yes to Confirmation Window.
A8. Save changes and exit Configuration Manager.

B. Continue with the Cognos PowerPlay Enterprise Server service:
B1. Launch Start --> Settings --> Control Panel --> [Administrative Tools -->] Services.
B2. Select Cognos PowerPlay Enterprise Server (cer2)
B3. Click Stop.
B4. Click Startup and modify the account service is started.
B5. Use a user account that has administrative privileges to both the server with SQL Server and to the Cognos server.
B6. Apply your settings and save.
B7. Restart the service.
B8. Close the services window.

C. Continue with PowerPlay Connect:
C1. Launch Start --> Programs --> Cognos EP Series 7 --> Tools --> PowerPlay Connect.
C2. In Database Type edit window: MS SSOS ODBO
C3. Server: SQLServerName
C4. Provider[;Catalog=name];CUBE=name, click the ellipsis [...]
C5. Choose a Remote Cube, navigate and select MSAS cube to be added.
This example uses Microsoft Foodmart 2000 Sample cube called Sales.
C6. Click Open once cube has been selected.
C7. IMPORTANT: in the description box enter an alias. This is MANDATORY.
I suggest the name of the cube as you want it known. For example, I will call this example 'Foodmart Sales'.
C8. Click File --> Save As.
C9. Give it an appropriate name. Ex Sales.mdc
C10. Close PowerPlay Connect.

D. Continue with PPES:
D1. Launch Start --> Programs --> Cognos EP Series 7 --> Cognos Server Administration.
D2. Click OLAP Cubes and Reporting.
D3. Connect to Server, click OK.
D4. Login if necessary.
D5. Select Insert --> Cube.
D6. To the right of Cube Source edit window, click the ellipsis [...].
D7. Navigate to the mdc file just created.
D8. Click OK.
D9. Change the name in the Name edit window if desired.
D10. Click OK.
D11. Close PPES

E. Continue with Access Manager:
E1. Launch Start --> Programs --> Cognos EP Series 7 --> Cognos Server Administration.
E2. Click Security.
E3. Expand Access Manager Administration --> Directory Servers --> MyServerName --> namespacename --> Data Sources.
E4. Right-click Data Sources and select Add Database.
E5. General tab: Name: MSAS Connection.
E6. Connection Tab: Database Type: Microsoft SQL Server OLE-DB.
E7. Click the Edit button.
E8. Database Definition: Provider: MSOLAP
E9. Data Source: SQLServerName
E10. Leave User Id and Password checked.
E11. Click Test.
E12. Enter User name and Password that accesses SQL Server database. If you are using Integrated Windows Authentication then your system logon name and password.
E13. Successful Attachment: Successfully attached to database MSAS Connection..
E14. Click OK. Click OK.
E15. Click Apply and then OK.

E16. Expand MSAS Connection to view Cubes and Signons folders.
E17. Select Signons.
E18. Right-click and select Add Database Signons.
E19. In the name edit window, add the name used to login to SQL Server. This user id must exist in the SQL Server Security --> Logins tab as Type: Windows User.
E20. In the password edit window, enter the password for database sign-in.
E21. Click OK.
E22. Repeat for all users/user levels.

E23. Select Cubes.
E24, Right-click and select Add In-Database Cube.
E25. IMPORTANT: The name entered MUST match the name entered in the Description field of the cube definition done in PowerPlay Connect.
This example used Foodmart Sales.
E25. Click the Edit button.
E26. Connections tab: Database Type: PPDS Remote.
E27. Click Browse button beside Database edit window.
E28. Change the Access radio button from Remote to Local.
E29. In the file name edit window, type *.mdc and press Enter.
E30. Navigate to the folder you saved your PowerPlay Connect file earlier and select the cube file.
E31. Click Open.
E32. Click Test
E33. Connection --> Connection Succeeded, click OK.
E34. Click OK
E35. Click Apply then click OK.

E36. Now we need to associate the Access Manager users with the MSAS users and the MSAS cubes.
E37. Drag the user from the Users list to the appropriate Signons login and drop.
E38. Drag the user from the Users list to the appropriate cube and drop.
E39. To verify a User listed in the Users list needs to have a Signons reference, Cube reference, Database reference and finally a User Class reference.

NOTE: With the above, you will be prompted once per session for a Cognos user id and password. Once validated, you will have seamless entry into the MSAS cubes.
F. To have seamless entry without a Cognos login, you will need to enable OS Signons within Access Manager for the users.
F1. To do so:
F2. Right-click on your NamespaceName in Access Manager Administration: usually default.
F3. Select Properties.
F4. Select the Signons tab.
F5. Check Active Signons to Both.

F6. For each user listed in the Users folder, right-click and select Properties.
F7. Select the User Signons tab.
F8. In the OS Signons area near the bottom, click the Add button.
F9. In the prompt window, add the domain and user id. Click OK.
F10. Click Apply and click OK.

G. Continue with IIS.

G1a. Win2000: Start --> Settings --> Control Panel --> Administrative Tools --> Internet Services Manager.
G1b. Win NT: Start --> Programs --> Win NT Option Pack --> MS Personal Web Server --> Internet Services Manager.

G2. Navigate to the Cognos virtual directory.
G3. Right-click the Cognos virtual directory and select Properties.
G4. Click the Directory Security tab.
G5. Click the Edit button in the Anonymous Access and Authentication Control section.
G6. Ensure the Integrated Authentication check box is checked.
G7. Uncheck the Allow Anonymous and Basic Authentication.
G8. Click Ok.
G9. Click Apply and OK.


You're done. You may be prompted to log in once, but ONLY once.

 

[naveenshindhe]

Good to see that answer,
Need 1 more help pls.
How to connect Access Manager to Impromptu.
Thanks
Naveen

 

[RicardoPereira]

I must have PowerPlay Enterprise Server ?
I only have the transfomer server with all the other tools (architect, ...)
I try to do all the steps but it doesn't work.

Ricardo