Balas Blog..

Wednesday, February 13, 2013

List of Resource Based on Role in Clarity

I am downloading the resources who is having the access to create the task under project.

Sample query

SELECT user_id,user_name
FROM cmn_sec_assgnd_obj_perm_r_v
WHERE object_type = 'RECORD'
AND object_code = 'PRJ_PROJECT'
AND permission_code IN ('prProjectViewer')
AND component_code = 'PRJ'

Happy Coding

Bala

Monday, February 11, 2013

Actuate Spreed Sheet - Connect and Configure Database

As i mentioned in the earlier post and open .vts file.

Step 1:

Click "Data Manager" in Data menu

Step 2:

You can use below connectivity to connect respective destination

- ODBC connection
- JDBC Connection
- File/URL Connection
- SAP Connection
- XML Connection
- Actuate data integration service connection

Step 3:

I have used ODBC connection to connect database for my report.

Note: There is a challenge, some time TNSnames.ora file configuration will not work here. better to create new connectivity datasource by using ODBC connection in control panel.
Also note: windows 7 - we need to use odbc bat file to create new datasource

happy coding
Bala

Actuate Spread Sheet Configure for existing report to modify

Step 1:
Install Actuate Spread Sheet report version 7

Step 2:
Download, There is a file name with extension called VTF.

Step 3:
Convert VTF extension in to .ZIP file and extract all the files.

Step 4:
After extraction, you can see three files with .vts,.guid and rop.
Example:
test.vts
test.guid
test.rop

Step 5:
we will take example of above mentioned files. open "test.vts" file, then it will take in to spreed sheet report to do the changes.

Note: The version 7, will not allow to open immediately, again you have to open same file by using
menu option "open".

Wednesday, January 30, 2013

Clearing the Caches in Clarity

In the URL

please type "Security.caches" in the clarity URL(Refer below URL) and enter you will see some buttons with flush and flush all.

please click on flush all and it will clear your cache.

http://serverlocation/niku/app?action=security.caches

happy coding
Bala

Tuesday, January 22, 2013

Clarity important tables to connect project and task.

Clarity important tables to connect project and task.
They are three tables

- odf_ca_project ( This will have the all the attributes created for project)
- odf_ca_task ( This will have the all the attributes created for tasks under project)
- prtask ( This is important table which will connect the project and tasks by using project id.)

Sample query to connect the task and project by using prtask table.

update odf_ca_task oct

set oct.wbso100 = 'Yes'

where oct.id in (select prt.prid from odf_ca_project odf,prtask prt

where prt.prprojectid = odf.id

and odf.wbso_subsidy = 'ws_yes');

Happy coding

Bala

Monday, January 21, 2013

Clarity 13 Offline Time sheet Will not be avilable

Clarity 13 Offline Time sheet

Offline time sheet will not available any more in clarity 13 release.

Configuring Actuate Spread Sheet Report.

Step 1:

Install actuate spread sheet report from Actuate website.

Step 1:

Mentioned below file require to do the modification.

Example: R175_Phi_Month_v0.1_qa.VTX design file you will get

Step 2:

Convert to the above file to zip file like this R175_Phi_Month_v0.1_qa.ZIP

Step 3:

After converting extract the zip file and you will fine three files.

- R175_Phi_Month_v0.1_qa.guid (Guid File)

- R175_Phi_Month_v0.1_qa (Actuate parameter Template)

- R175_Phi_Month_v0.1_qa (Formula one file)

Click on the Actuate parameter template file, it will open in the spread sheet environment.

some time if does not open, please reopen through actuate spread sheet.

Step 4:

After opening go to Data file and then click "Data manager", you can find the connection and query,

if you have any connection issue in the odbc. create connection through ODBC driver.