Resetting rpd Password (Informative)

Hello Everybody,

When i am doing some R&D work today, I come across a situation how to reset the password for rpd where I forgot the password for Administrator. All existed solutions (like NQSChangepassword.exe command) have associated with mentioning old password to get the new one.

The work around I found:

 Open NQSConfig.INI file

 Go to Security part and find AUTHENTICATION_TYPE = BYPASS_NQS;

 Uncomment this part

 Stop the BI Server service

 Close Administration Tool, if opened. (Then only the changes are affecting to the Administration Tool)

 Open Administration Tool, then rpd which needs password reset, in offline mode

 Give any password here, it accepts.

 Now go to Manage > Security.

 From here it’s the normal process how you change password for Administrator.

 Save the changes to rpd

 Revert back the changes in NQSConfig.INI

 Start BI Server and open rpd with new password.

I am not aware of whether it is bug or something else, and don’t even know any other best solution exists for the same. Using Import from Repository hope we can do this... As it's deprecated and the above procedure is the simple one, i am using this...

Outer join

Yes,But it will degrade the performance of the report because it should pick up values of dimension column for the correspoding fact values which will be null.So data picking will be more......If you dont have large data then you can go with the outer join comfortabllly in BMM layer of the join property window on the middle left hand side you find drop down to select it as outer join.

Re: Filter - Too Many Values
Posted: Jan 24, 2011 4:24 AM in response to: sliderrules

Correct

Hi,

Drop Down list can handle a maximum of 256 values but if we want more in dropdown

Add the below code in instanceconfig.xml under ServerInstance tag

<Prompts>
<MaxDropDownValues>10000</MaxDropDownValues>
</Prompts>

*Restart presentation services
Refer : http://varanasisaichand.blogspot.com/2010_03_01_archive.html

Re: Request Variables
Posted: Aug 26, 2008 4:28 AM in response to: hendrti

Hi,

A Request variable is the same as a session variable. Setting this variable overrides the value which has been set via the initialization block in the repositor

Re: Pagination in OBIEE
Posted: Feb 1, 2010 5:52 AM in response to: user622572

Hope, the mentioned steps only helps in Presentation layer Pagination.

I want to control the number of records BI server fetches from Database (Pagination at DB level) .

I am observing BI server fetching all the records from DB in the intial query execution itself even though the presentation layer requires only 25 rows per page.

TRUNCATE((RCOUNT(1)-1)/10, 0) +1

CASE WHEN RCOUNT(1) < 11 THEN ’1-10′
WHEN RCOUNT(1) < 21 THEN ’11-20′
WHEN RCOUNT(1) < 31 THEN ’21-30′
ELSE ’30+’ END

TOPN("F1 Revenue"."1-01 Revenue (Sum All)", 10 by "D2 Market"."M01 Market")

I have a pivot table in which im doing cross columns analysis and here some of the cells are blank.
My requirement is I want to set value of a blank cell to " 0 " , which means all the cells without any value should show "0".

Empty in pivot table cell (no value)in sales

Colformat: customà#,##0;-#,##0;0

Re: how to drill down in combine request
Posted: Jan 19, 2011 4:02 AM in response to: Prashant

Helpful

Once you combine requests the drilling is disabled, if you think about it, if you have combined requests across different subject areas, how does the BI Presentation services know that the next column to drill to is available in all subject areas, and indeed that the next level is uniform across Subject areas in that dimension?

The best workaround I can think would be to set up navigation to a pre-prepared report to simulate drill down, you will have fun passing the values to the child report as Im pretty sure this doesnt work when combining requests either, you are left with manually crafting a GOURL path to the next report, using the GOURL parameters to pass the filters , this path goes in as the column formulae and you format that column as HTML or CustomText.

Im not 100% sure that the GOURL will pass the params to a report build using the combine requests method, you will have to try this out. You can certainly navigate to a dashboard page and set the dashboard prompts which could effect the report if you wanted.

Click on Answers->Left side below Shared folders you can see reload server metadata,click on that.

Assign points if reply helped u

What is the difference between Storage Grain and Query Grain ?
Select quarter, YearAgoSales:

Query grain: quarter
Time Series grain : year

what is the Storage Grain ?

As mentioned in Help Guide, Storage Grain is "grain of the aggregate source".
Quite simply it is the grain at which your data is held in the fact table. I.e. You will most likely have one row per day or week or month in this case.
torage grain: by its name is the grain of your source.
query grain: by its name is the grain at which you define your query.

based on the example you mentioned:
Though you have a source at day grain, you are querying at quarter level (which corresponds to query grain)....

mark posts promptly

Re: how to make the best data model in the RPD in Business layer
Posted: Jan 12, 2011 6:41 AM in response to: user12077461

Helpful

hi user,

Few things u should keep in mind

1) Take the tables and find the relation ship between those(pk-fk)

2) Identify Dim's and Fact's

3) After step2 definitely there will be a division of header level and detail tables

4) Dim1 having Business_Date and Fact1 having Business_date u can join in this way

5) Normally without ETL we may go for Pl/SQL or SQL's.Your Data model will come under this point

6)In BMM layer u can form Start Schema/Snow flake schema

Re: Session Variables For Region Validation
Posted: Jan 6, 2011 4:40 AM in response to: cycon

Helpful

Hi,

Add an entry for the Administrator to your Initialization block;

SELECT region_name FROM user_region WHERE user_name = LOWER(':USER')
UNION ALL
SELECT 'All Regions' FROM dual WHERE LOWER(':USER') = 'administrator'

Use the 'All Regions' in your filter. Add an OR-statement; OR 'All Regions' = SESSION_VARIABLE_REGION

Replace

Like
8:30:00 into 83000 In custom

Re: Don't want the "No Data" message coming from OBIEE - Any ideas?
Posted: Jan 5, 2011 9:28 AM in response to: user10693087

Hi

there is view called: "No Results" view in compound Layout drop - down list..
Give your custom message there

got my no data report working. I just added a blank space (" " ) in the custom No Results view of original report and I also added a javascript to take out the refresh link from there. Later I added my No Data template to the original report through guided navigation.

Re: How would I find a maximum among 4 columns
Posted: Sep 10, 2008 11:57 AM in response to: wildmight

not that i know of.

if you need case statement, this will save you some time:

case when Table.column1 >=

case when ifnull(Table.column2, 'somelternatevalue') >= ifnull(Table.column3, 'somelternatevalue') then case when ifnull(Table.column2, 'somelternatevalue') >= ifnull(Table.column4, 'somelternatevalue') then Table.column2 else Table.column4 end else case when ifnull(Table.column3, 'somelternatevalue') >= ifnull(Table.column4, 'somelternatevalue') then Table.column3 else Table.column4 end end

then Table.column1

else

case when ifnull(Table.column2, 'somelternatevalue') >= ifnull(Table.column3, 'somelternatevalue') then case when ifnull(Table.column2, 'somelternatevalue') >= ifnull(Table.column4, 'somelternatevalue') then Table.column2 else Table.column4 end else case when ifnull(Table.column3, 'somelternatevalue') >= ifnull(Table.column4, 'somelternatevalue') then Table.column3 else Table.column4 end end

end

This time we will see something about Time Series Calculations in OBIEE.

We have two functions which we can use for this.

1. Ago - This function is used like to calculate like previous month sales,previous year sales or last to last year sales etc.It has three parameters

i.Measure(sales,revenue etc)

ii.Level to roll up(previous month,year,quarter etc)

iii.Number to roll up(1,2,3 etc basically an offset)

i.e To calculate previous month sales we can write ago(sales,month,1)

2. ToDate – This fucntion is used to calculate the measure for month to date, year to date,quarter to date etc.It has two parameters.

i.Measure(sales,revenue etc)

ii.From which level calculation should start(month,year,quarter etc)

i.e To calculate sales on month to date we can write ToDate(sales,month)

have a report where data is pulled at region level
regions are say :A,B,C,D,E,F,G,H

Now we have a reqmt from one of our client to group the regions and classify them as grades.But we don't have any grades in our database.This reqmt is for users of a specific country only so we don't want to add this new grade column to our database.We want to create a new dummy column for this specific report only and want to hard code the grades like this

Grade Top : Regions are A,B,D
Grade Bottom:Regions areC,F,G
Grade Middle:Regions areE,H

So the reqmt is i want to add a new dummy column (only for this particular report) called Grade with three values :Top,Bottom,Middle

CASE when Regions in ( 'A','B','D' ) then 'Grade Top'
when Regions in ( 'C','F','G' ) then 'Grade Bottom'
when Regions in ( 'E','H' ) then 'Grade Middle'
END

CASE Table.Column WHEN 'A' THEN 'Grade Top'
WHEN 'B' THEN 'Grade Top'
WHEN 'D' THEN 'Grade Top'
WHEN 'C' THEN 'Grade Middle'
WHEN 'F' THEN 'Grade Middle'
WHEN 'G' THEN 'Grade Middle'
ELSE 'Grade Bottom'
END

hi how to increase the dropdown list valese in obiee
Posted: Jan 3, 2011 11:21 PM

hi all,

in my drop down list i am getting only 250 values
i need to display 1000 values in the prompt....
so wat i have to do?

<Prompt> <MaxDropDownValues>1000</MaxDropDownValues> </Prompt>

this code i have added in instanceconfig.xml file
and i have restarted the services ..even i did not see 1000 values in my prompt

what is the problem ?please any one can help me

e: Want to include spaces in the Results in the Text field.
Posted: Jan 2, 2011 10:56 PM in response to: bkjatania

Correct

Hi Bhavik,

try this, go to column properties -> Dataformat -> Change treat text as drop down -> plain text (don't break spaces).
this will allow spaces.

Re: Aliases in physical layer
Posted: Dec 31, 2010 7:31 AM in response to: user12077461

Helpful

Once you created your alias tables, it is a best practice to use this for the joins. Thus, there is no need to join your original physical tables.

Alias have a lot of advantages like:
1. reusing the same physical table more than once to create an alias and create a completely new join
2. you can setup multiple alias tables with different keys or joins
3. used to convert the ER schemas to dimensional schemas in designing star/snowflake schema

Hi,

use

CASE WHEN "Orders - Sales Order Detail"."SOD_Date Promised Shipment" > CURRENT_DATE
THEN "Orders - Sales Order Detail"."SOD_Date Promised Shipment"
ELSE
TIMESTAMPADD(SQL_TSI_DAY,-2,current_date)
END

Re: Current_date -2 in Case Statement
Poste: Dec 27, 2010 11:10 PM in response to: Manomohan

Helpful

Add custom images to dashboard

Posted on September 6, 2010 by bintelligencegroup

In order to add custom images to dashboards,we can use some images already present under this folderOracleBI\oc4j_bi\j2ee\home\applications\analytics\analytics\res\s_oracle10\images(or) If we want some new images other than images in the images folder add those images at above mentioned path and OracleBI\web\app\res\s_oracle10\images

*Restart services after adding new images

To show those custom images on dashboards we need to give fmap:images/(image_name.jpg under the above path)

*Use forward slash

EG: fmap:images/report_agreements.jpg

Configure Oracle Business Indicator
Posted: Dec 22, 2010 8:32 AM in response to: CedricG

Correct

Hi,

1- Add those two lines to your instanceconfig.xml to generate png instead of flash chart (because flash is not supported)
<Charts>
<DefaultImageType>PNG</DefaultImageType>
</Charts>

2- Install the app from the appsotre
3- in Buiness indicators enter your environment URL adress and put your administrator user password (if your are using SSO don't forget to enable it)

That all what you need to do if it's not a problem for you to have only one Presentation server.because with PNG you loose every graph interactivity.

If it's a problem then follow this tutoriel to deploy a second PS plugin.
http://rnm1978.wordpress.com/2009/08/25/multiple-rpds-on-one-server-part-2-presentation-services/

#,###.#0

# ## ### ###.#0

Re: Erase My Dashboard from Dashboards
Posted: Dec 17, 2010 3:53 AM in response to: user7689108

Helpful

1)If u want to change MY Dashboard name then try thsi one
In OracleBI\web\msgdb\l_en\messages search for My Dashboard
you can find this tag
<WebMessage name="kmsgUIMyPortal"><TEXT>My Dashboard</TEXT></WebMessage>

Here replace the My Dashboard to your custom name.

2)If you want to hide My Dashboard then

Administator -> Manage Privileges -> Catalog -> Personal Storage(My Folders and My Dashboards) -> Give security as denied to everyone

Thanks

e: Group by 30 min interval
Posted: Dec 17, 2010 2:07 AM in response to: Govind

Hi...

One way to meet your requirement, we need to create an aggregate table with three columns RollupTime_30, Agg_KPI1, Agg_KPI2. This solution improves the performance as the calculations are stored in Database as part of ETL Task and made ready for the BI Server to fetch the results.

The Agg_KPI1 and Agg_KPI2 columns are populated with the return values from two PLSQL functions. These functions are used to aggregate the data to the rollup Interval i.e., 30mins when the interval value and Time are passed as inputs.

Function AggKPI1_Fun(Time Varchar, Interval Number)
return Number
AS
Val Number(5)
Begin
....Select query to load the value into val;

End;

Hope this wor

try some thing like this

TIMESTAMPADD(SQL_TSI_MINUTE, CASE WHEN MINUTE(DATETIMESTAMP_COLUMN) < 30 THEN 30-MINUTE(DATETIMESTAMP_COLUMN) else 60 - MINUTE(DATETIMESTAMP_COLUMN) END, DATETIMESTAMP_COLUMN)

Re: Restricting Values in Dashboard Prompt
Posted: Dec 10, 2010 8:36 AM in response to: 792011

While creating dashboard prompt, In show -> choose SQL results -> enter the sql there
sample sql,
SELECT table.customer_name FROM SubjectArea
Where table.customer_name IN ('Name1', 'Name2','Name3', 'Name4','Name5')

Re: Hiding Drop down box in Pages Section in Pivot View
Posted: Dec 9, 2010 7:48 PM in response to: Karthik

Correct

Hi Karthik,

You can hide the drop down by adding css code,

In Answers add a static text/ narrative view and add the below code (enable html)

<style type="text/css">
.PromptTable
{ display:none; }
</style>

otherwise in dashboard add text and enter the above code there..
this will hide the drop down.

Re: Report level formatting for timestamp
Posted: Dec 6, 2010 8:31 PM in response to: Chin

Helpful

hi VIS,

Column Properties-->Data Format-->click on Save--->"as the system-wide default for this data type" you no need to change every time

Thanks,
Saichand.v

Re: Evaluate Function
Posted: Dec 6, 2010 9:39 AM in response to: Copter

Helpful

Change your evaluate function code

EVALUATE('TO_DATE(%1) AS DATE',"Tablename"."columnname")

to

EVALUATE('TO_DATE(%1)' AS DATE,"Tablename"."columnname")

As TO_DATE function requires a specific format (which is missing in the formula specified - EVALUATE('TO_DATE(%1) AS DATE',"Tablename"."columnname")).
Try this, EVALUATE('TO_DATE(%1,%2)',"Tablename"."columnname",'yourdateformat')

Re: How to get sql behind a report.
Posted: Jan 19, 2011 7:28 AM in response to: Deepak

Hello,

Can U try this....

Open your RPD > Mange > security > users > click administrator > Logging level > make it "2" from "0".

Hope it helps

Please close the thread if its helpful.

Re: getting sysdate in a variable
Posted: Nov 30, 2010 1:02 PM in response to: Copter

Correct

Hi,
First create one Intilization block in Repository( ie. Manage -> Variables)
In the Intilization Block give this SQL: select sysdate from Dual.
Know it will give one value. Store this value in Dynamic Variable.

e: InstanceConfig.xml Tags
Posted: Nov 9, 2010 3:34 AM in response to: Kranthi

Hi Kranthi K,

In fact I change my tag :

- <views>
- <table>
<defaultrowsdisplayedindelivery>700</defaultrowsdisplayedindelivery>
</table>
</views>

like this :

- <Views>
- <Table>
<DefaultRowsDisplayedInDelivery>100000</DefaultRowsDisplayedInDelivery>
</Table>
</Views>

and it works

Re: .atr
Posted: Nov 2, 2010 1:28 AM in response to: Chaitanya

Helpful

Chaitanya,

.atr is something a attribute file which will store our information in hexa decimal code format

If u stroe any report or filter /security group/user....u ll find their respective .atr file in CATALOG folder

Re: Format of the report for the Scheduled Reports($,%)
Posted: Oct 30, 2010 9:32 AM in response to: user12077461

Correct

For your currency, try using this in your custom format:

$#,##0.0000_)

For your percent, try using this in your custom format:

###,##0.0000%

Re: dashboard tab in multi-language
Posted: Oct 27, 2010 4:20 AM in response to: user770890

Hey Manna,

Here is the file

\OracleBI\web\msgdb\messages\preferencestemplates.xml

Check for the right "messageRef" and make the translate ="yes"

Try it out , i didn't test locally sorry

Re: To display first and last dates of a month
Posted: Oct 26, 2010 11:27 AM in response to: user12077461

Do one thing,

i'm assuming that you've monthnumber and year columns..
And, assign a presentation variable to the Date prompt.. (var_Date)
Now, apply the following condition in filters part of your report..

MonthNumber = Month(Date'@{var_Date}')
And
Year = Year(Date'@{var_Date}')

Month Number, year should of INT datatype...

Re: dispaly _ value in column
Posted: Oct 27, 2010 12:28 AM in response to: 727225

Helpful

USER,
Use the following syntax

CASE WHEN Products."Product Type"='Type 1' AND Time."Month"='2007 / 03' THEN Time."Month" ELSE '-' END

Thanks,
Saichand.v

Re: OBIEE:Cache is not clearing
Posted: Oct 27, 2010 5:55 AM in response to: Mervin

Helpful

Mervin,

1) What is the loglevel that u setted for the user?

2) Try to Disable the Cache in NQSCONFIG.INI and try anyhow u ll not get any cache at rpd

Check whether this variable has used in advanced tab

http://bischool.wordpress.com/2009/04/06/set-loglevel-from-answers/

Re: what is the user of contant table in LTS
Posted: Oct 25, 2010 6:30 AM in response to: 791907

Correct

Sreedhar ,

Example of Creating Sources for Each Level of Aggregated Fact Data

In addition to creating the source for the aggregate fact table, you should create corresponding logical dimension table sources at the same levels of aggregation.

NOTE: If the sources at each level already exist, you do not need to create new ones. You need to have at least one source at each level referenced in the aggregate content specification.

For example, you might have a monthly sales table containing a precomputed sum of the revenue for each product in each store during each month. You need to have the following three other sources, one for each of the logical dimension tables referenced in the example:

* A source for the Product logical table with one of the following content specifications:
o By logical level: ProductDimension.ProductLevel
o By column: Product.Product_Name
* A source for the Store logical table with one of the following content specifications:
o By logical level: StoreDimension.StoreLevel
o By column: Store.Store_Name
* A source for the Time logical table with one of the following content specifications:
o By logical level: TimeDimension.MonthLevel
o By column: Time.Month

Fieriant

Just give #,##0;-#,##0;- or #,##0;-#,##0;CustomMessage in dataformat.

ORACLE BUSINESS INTELLIGENCE ENTERPRISE EDITION 100

iforums

Add custom images to dashboard

iforums

Add custom images to dashboard

Subscribe To