Measure prompt
Hello
Taking the reference of this OTN Post I thought of playing around prompts and measure columns.
The exercise is based on Sample Sales Lite SA ( XML Based SA )
Environment- OBIEE 11.1.1.6.0 ( Windows 7 -32 bit /Tested on IE 8 )
SA- Sample Sales Lite
Create an analysis of 3 columns namely
1> "Time"."Per Name Year"
2>"Base Facts"."Revenue"
3>"Base Facts"."Revenue"
I would rename the columns ( no. 2 & 3 ) as shown in the snapshot below.
Column formula of column no 2
Column formula of column no 3 ( You can have complex calculation - In the given example I have used a very simple one )
Save the report. [R1]
Go
back to home page and once again navigate to Sample Sales Lite SA.Take 2
to 3 measures for example in the analysis and capture their names from
the respective column formulae.We would need this while creating a
dashboard prompt. Look at the below snapshot.
"Base Facts"."Revenue"
"Base Facts"."Billed Quantity"
"Base Facts"."Discount Amount"
Now go to dashboard prompt editor.Select the option Variable Prompt.Add the details as shown in the below snapshot.
Save the prompt and pull it on the dashboard with the report R1.
Select
the first measure ( Revenue ) and hit apply.You will see the Revenue
measure values getting populated in the second column while values of
3rd column would base upon the 2nd column that we select from the
prompt.
You may find blogs on changing the column name dynamically.
I
have to test this solution against an SA based on a relational database
and perform multiple rounds of testing. Try it out - You may find some
even more interesting facts.
Changing the placement of currency name
Usually
currency symbol is shown before the currency value ($1000) and currency
name appears after the value (1200 USD). In OBIEE,currency name/symbol
formatting is handled by currency.xml
Have a look at this report.
In my case currency name is INR.
I want INR to be appeared before the AMOUNT_SOLD column value.
Let us go and open the currency.xml and search for the currency name INR.
Edit the highlighted line. Add a tag : format="$ #"
This will look like:
Save the changes. Restart the BI services. Reload the metadata and clear the browser cache.
Now let's look at the result.
Click on a column value and open a file in OBIEE11g
I want to show a file ( it could be any type of file ) when I click on any of the column values , in OBIEE11g.
1> Create a folder in Shared Folders - ex, DOCS
2> Go to that folder and upload the external file ex . e10540.pdf
3> In the analysis, Take a column , go to column properties,Interaction tab,
Add action links , select Navigate to web page and use the URL as shown in the format below.
http://usblrnmehandal1:7001/analytics/saw.dll?downloadFile&path=%2FShared%2FDOCS%2Fe10540.pdf
Copyright message - Edit footer in the dashboard
This assignment is based on OBIEE 11g version.
Open the Edit dashboard option. Select PDF and Print properties.
Choose Include Footer and press Edit.
Type your message
As per your requirement you can do the customization and play around with the available options.
(Note
: If you want the message not to be displayed in the dashboard but
wanted the same when exported in PDF or Excel then place your message
in <NOSCRIPT>Copyright message</NOSCRIPT> with the HTML option on.)
Save the changes. And run the first page of your dashboard.
Redo the same thing for the remaining dashboard pages.
In order to add the header/footer automatically, refer
http://obiee1000.blogspot.in/2012/01/show-header-image-automatically.html
