activate dataslices automatically

[Former Member]

Hi All,

I have a requirement in BI IP where I have to lock down the plan data with certain versions dynamically i.e when the endusers save the snapshot of forecasts data as monthly and annual versions ,these versions should be locked dynamically.

The only solution I can think of is to activate the dataslices automatically. Write the code in fox to call a function module that activates the dataslice.

I have read the forums where the activation/deactivation of datslices have been discusssed but looked pretty complex to me.I feel there should be some function module that activates the dataslices.

Any suggestions on this will be of great help!

[Former Member · Accepted solution]

You can use variable in the definition of the dataslice to lock the data dynamically.

For example, I use a variable on the period who return the closed periods of the year in Forecast and the dataslice is always active.

[Former Member · Accepted solution]

But do you think the value of this variable can be passed by the enduser from the BEx analyzer. I want the enduser to lock the data once it is approved.

[Former Member · Accepted solution]

You can give one button to the user to lock versions, the function inside which will create an entry in the version (dataslice variable) at runtime which automatically locks the dataslice.

[Former Member · Accepted solution]

Bindu:

Thanks! for you reply. Now the question is how do I create a function which creates the dataslice for the values that I pass for versions dynamically. How should I proceed from here.

Indu:

Thanks for your reply:

Well Indu..you suggested creating exit variable for versions and pass this value from bex analyzer to lock the data using the dataslice. I am kinda confuse about the exit variable for versions, can you tell me what logic or code do I require to set up exit variable so that I can use the variable in dataslices and fox code.

[Former Member · Accepted solution]

Create a dataslice with version restricted by a fixed variable with no entries initially. Make this dataslice active. The function is an exit function which reads the version value selected by user and writes an entry in to the data slice version variable. As the active dataslice is restricted by this variable and it has the version selected by user, it will lock that data. Its absolutely possible in BPS, You can give a try for IP.

[Former Member · Accepted solution]

I know how to read the value of variable through the fox code but how will I feed this value to the fixed variable of dataslice. Don't u think there should be some function module that sends the value of the variable to dataslice and activates just like in BPS it got a table name UPC_DATASLICE.

Edited by: Nazeer on Sep 11, 2008 6:02 PM

[Former Member]

You can pass the value of the variable from the BEx analyzer in an exit variable,which you can further use in the data slice to lock the data as well as at the same time you can use the value of this exit variable in FOX, to compare and proceed further accordingly.

Rgds,

Indu