Skip to Content

How to change the Provider-Specific Properties of an infoObject in a cube w/o dropping data

Hi All,

My requirement is to fix the fiscal year with a constant value (2013) in a cube so as to improve the query performance (the query is on top of a MP - which has many other cubes with year-wise data). Since the 2013 cube is already loaded with data, I am unable to state the constant value in Provider-Specific Properties.

Can anyone tell me if there is any workaround or solution to change the Provider-Specific Properties of an infoObject in the cube w/o dropping data?

Regards,

Ravi

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 08, 2013 at 02:55 PM

    i dont think you could fix it in that cube.. as you will need to reload the data ..so in other words you are changing all the values for fiscal year to 2013, if you do filter in query it will only bring in 2013, you could write a user exit to convert all years that you have to 2013 in query run time.. or create another cube on top of this cube, and in your misinformation have 2013 as constant and load the data there and copy all the queries to the new cube and that should help you.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.