on 04-24-2014 7:31 AM
Hi,
I have a requirement in my dashboards where in i need to create a Scorecard component and following are the detailed requirements.i am using the SAP Dashboards 4.0 tool.
1) There will be a drop down box which will display some employee names in it.
2) When the user selects a employee value from the drodown then the score card below the Drop down display the associated projects information
and The first column of the scorecard component will display the respective Project names.
3) And for each project there will be an associated .pdf document saved in share point location.
4) So the user wnats to see this pdf document after he clicks a project name from First column of the score card component.
So i would like to know the detailed step by step approach how can i link each one of the pdf document to the respective project in the score card component.
what i mean if i have multiple projects under one Employee how to link one PDF document for one project.
Here employee to Projects is a 1 to Many relation ship. and Project name in score card to pdf document in sharepoint is a 1 to 1 relation ship.
I hope you understand the requirement clearly.
Any body knows how to implement this requirement please let me know your inputs at the earliest.
Thanks in advance,
Warm Regards,
Nanda Kishore.
Hi Nanda Kishore,
You can also try this......
In Scorecard you can create a series and say insert type as 'Position' now map destination to any blank cell.
In Behavior Tab say 'Rows are Selectable' and in Item: "No Selection (None)"
now whenever you select any row, Destination of series will update with number, you can trigger URL when value changes or when value becomes to a specific number then select to open particular project document in the same order they are populating using if else formula
you can hide this url button at the back of combo box
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sandeep,
I did tried this approach.However i need to click on the URL button to open the respective project document.but i don't want to click on this URL button.,
so how to achive this without click of the URL button.i.e (click the project name cell in score card component, automatically the repective project document should be opened in a New window.
Any dody knows how to implement this please reply asap.
Regards,
Kishore.
Here are the steps you can follow
step 1
add scorecard and map them to data
Step 2:
add series and select Position in 'Insert Type' and bind to a cell
Step 3:
Go to behaviour and say rows are selectable and select 'No Selection (none)'
step 4:
Add URL button and assign url to it for your project
step 5:
Go to Behavior and map trigger cell to E1 where we are capturing selections from scorecard
Same for third URL button but specify when value becomes as 3 as its our 3rd row
Step 6: now hide the url button
and set it back and hide this url button in the back of scorecard
Hi Nanda Kishore,
I have tried the above requirement,we cant get share point location by using spread sheet,we should have to use URL button.
--> Take a combo box component and map the projects.
-->Map below 3 columns as source and take empty rows as destination
project | emp name | URL |
PRJ_1 | samatha | S:\Projects\prj1.txt |
PRJ_1 | mahipal | S:\Projects\prj1.txt |
PRJ_1 | ganesh | S:\Projects\prj1.txt |
PRJ_2 | sabarish | S:\Projects\prj2.txt |
PRJ_2 | samatha | S:\Projects\prj2.txt |
PRJ_2 | raj | S:\Projects\prj2.txt |
-->And map the project names and employees column in spread sheet
-->Take URL button and place it on 1st row
-> In appearance tab uncheck the show button back ground
-->Map URL column destination to URL button.
now by clicking on project we will get the shared point location.
Regards,
Samatha B
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.