OTN Discussion Forums : Converting BSO to ASO ...

Reply to this Thread

Search Forum

Back to Thread List

Replies: 8 - Pages: 1 - Last Post: Nov 12, 2008 5:08 AM Last Post By: Mohammed Shariff

Hypguy

Posts: 26
Registered: 11/21/07

Converting BSO to ASO
Posted: Nov 21, 2007 5:56 PM

Hi guys,

can any one help me out in converting BSO to ASO
may be its scilly but i got stucked up in the process....

thanks for any response in advance.

Suresh

Sandeep Reddy

Posts: 1,243
Registered: 09/05/07

Re: Converting BSO to ASO
Posted: Nov 21, 2007 7:00 PM

in response to: Hypguy

Suresh,

Where exactly ,are u stuck.
One can use "Aggregate Storage Outline Conversion " wizard.In the first step of conversion , it provides the informatin of the members ,which needs to be corrected .
You find this wizard in
Wizard - > Aggregate Storage Outline Conversion.

Sandeep Reddy
HCC

Hypguy

Posts: 26
Registered: 11/21/07

So great full for your reply
Posted: Nov 21, 2007 8:38 PM

in response to: Sandeep Reddy

Hi Sandeep,
thanks a lot for your reply dude,,,the thing is i didnt really tried for the conversion,
im in search of a job on Hyperion , so i would like to know the process of converting BSO to ASOs. i only know that we can covert BSO to ASO and i dont know the process,,,,can you tell me the process of conversion.
thanks again for your help dude.
suresh.

Dornakal

Posts: 412
Registered: 11/14/07

Re: So great full for your reply
Posted: Nov 22, 2007 2:15 PM

in response to: Hypguy

Hi Suresh,
you can find details of conversion of BSO into ASO in technical documentation.
the main thing, anyone would ask you in interview is differences between ASO and BSO.......In what scenario you can use ASO or BSO
how kernal (storage) differs in two types etc.
you can find all the above information in DBAG in detail.
good luck with your search.
hope this helps

Hypguy

Posts: 26
Registered: 11/21/07

thanks
Posted: Nov 22, 2007 9:42 PM

in response to: Dornakal

Thanks dornakal,,
actually i was through the Dbag file, they didnt mentioned about the procedure for converting BSO to ASO.
can you tell me is there any other important issues to be likely to ask in interviews in ASO Vs BSO other than Conversion and differences

Dornakal

Posts: 412
Registered: 11/14/07

Re: thanks
Posted: Nov 29, 2007 12:10 PM

in response to: Hypguy

Hi Suresh,
here is some info from DBAG:
"You must create an aggregate storage application to contain an aggregate storage database. An aggregate storage application can contain only one database.
You can create an aggregate storage application, database, and outline in the following ways:
●Convert a block storage outline to an aggregate storage outline, and create an aggregate storage application to contain the converted database and outline.
●Create an aggregate storage application and database. The aggregate storage outline is created automatically when you create the database.

Note: An aggregate storage outline cannot be converted to a block storage outline.

To convert a block storage outline to an aggregate storage outline, use any of the following methods:
AdministrationServices :Aggregate Storage Outline Conversion Wizard

Note: Do not use the file system to copy a block storage outline into an aggregate storage application. Use the Aggregate Storage Outline Conversion Wizard in Administration Services to convert the outline.

please go through chapter "Creating, Calculating, and Managing Aggregate Storage Databases"

hope this helps

Hypguy

Posts: 26
Registered: 11/21/07

Re: thanks
Posted: Dec 3, 2007 8:15 PM

in response to: Dornakal

thanks a lot for the information man,,,,that was really helpfull
great information.

Rasheed

Posts: 18
Registered: 12/31/07

Re: Converting BSO to ASO
Posted: Jan 1, 2008 1:21 AM

in response to: Hypguy

you have to do the following things
1.convert a Block storage outline to Aggregate storage outline & create a aggregate storage application which contains the converted database and outline
(or)
create an aggregate storage application and database. The outline will be automatically created during the creation of database.
2.Sparse/Dense properties of BSO should be replaced with Dynamic/stored/multiple/alternate hierarchies in ASO respectively
3.the calc scripts in BSO does not work in ASO ,so write the calculations in MDX script(Multidimensional Expression)
4.Instead of using Two-pass calculations in BSO,we should use "Solve Order property" in ASO
5.make sure that "Dynamic Calc" & "Dynamic Calc and Store" are not present in ASO because they are not applicable in ASO applications.
6.In ASO, the data will be loaded at zero level members.

Mohammed Shariff

Posts: 36
Registered: 09/21/08

Re: Converting BSO to ASO
Posted: Nov 12, 2008 5:07 AM

in response to: Rasheed

Some points Adding for your help.

This topic lists the key design considerations when you create aggregate storage database outlines. Consider the following information when designing an aggregate storage outline:
●Use stored hierarchies (rather than dynamic hierarchies) as much as possible.
●Use alternate hierarchies (shared members) only when necessary.
●Minimize the number of hierarchies.(For example, each additional stored hierarchy slows down view selection and potentially increases the size of the aggregated data).
●If a hierarchy is a small subset of the first hierarchy, consider making the small hierarchy a dynamic hierarchy. Considerations include how often the hierarchy data is queried and the query performance impact when it is dynamically queried at the time of retrieval.
●The performance of attributes is the same as for members on a stored hierarchy.
●The higher the association level of an attribute to the base member, the faster the retrieval query.

Edited by: user10306151 on Nov 12, 2008 5:08 AM

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)