Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] regarding currency conversion

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] regarding currency conversion
 Login/Join
 
<swapna>
posted
hi,

can we have a drop down for currency where in the column "currency" is not in any of the tables tat we have.
Do we have any in built function in webfocus which generates it in OLAP????

This message has been edited. Last edited by: Kerry,
 
Report This Post
<JG>
posted
quote:
where in the column "currency" is not in any of the tables tat we have.


1st. If it's not a silly question how do you expect to populate it if you do ot have the data?

2nd. WebFocus does not have the functionality to display drop down boxes in OLAP.

If you want that sort of functionality look at using flash,AJAX or javascript EXT Grid to display the data
 
Report This Post
<swapna>
posted
JG,

Now i have two tables....

"Curr_Code_Details" which has the cols-- Curr_code,Curr_year and Curr_rate.

"Supp_detaills" which has the cols---- supplier,plant,Spend_on_YTD,Spend_on_month.

Based on the Currency code selected from the table "Curr_Code_Details" we need to convert the col Spend_on_YTD
to its respective currency.

Pls suggest...
 
Report This Post
<JG>
posted
Unless you use the methods that I suggested i.e. Flash,AJAX or EXT GRID you cannot dynamically change the source column used in a calculation once a report has been generated.

The only option is to make currency selection a user input parameter i.e. variable before the report is run
and use the required currency to generate the report.

If the user wants to see it in a different currency the report must be rerun.

This can be achieved by generating the currency selection as a dropdown in the report
which uses the new selection to run thge same report (effectivly as a drilldown) with that selection.
 
Report This Post
GinnyJakes
Expert
posted Hide Post
Hey, fellas.

Can you both update your profile signatures with your products, releases, and platforms?

Thanks.


Ginny
---------------------------------
Prod: WF 7.7.01 Dev: WF 7.6.9-11
Admin, MRE,self-service; adapters: Teradata, DB2, Oracle, SQL Server, Essbase, ESRI, FlexEnable, Google
 
Posts: 2723 | Location: Ann Arbor, MI | Registered: April 05, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] regarding currency conversion

Copyright © 1996-2020 Information Builders