TM1 Forum

Hi,

I have tried to give demo like how DB functions in excel works the demo was for how to get Normal excel sheet data into TM1 database(to sliced excel sheet), the procedure I tried is

1) I have taken slice from from a cube view and updated it in Application folder as .xls file and published to TM1 Web.

2) I have taken Normal excel sheet and updated the sheet on to Application folder with .xls file and publised to TM1 web.

3) At the excel level under server I have cut a one cell value with DBRW formula and pasted it on Normal excel sheet. Then I entered value in sliced sheet in that particular slice and reflected back in Normal excel sheet and vice versa.

4) Now I saved both the sheets and updated on Application folder.
5) I log in into the TM1web on the Web Application folder, I opened Normal excel sheet , I am unable to see the updated data on TM1Web for the normal excel sheet, where as I can see the same updated data on Sliced excel sheet.

Please can any one give suggestions why Normal excel sheet data is not updated on TM1 web.

PLease help me in this.

TM1 9.5.2
Excel 2007

Any suggestions

charan wrote:Any suggestions

First of all you may note the day of the week. You aren't necessarily going to get a lot of suggestions on Sunday/Saturday as the case may be, especially not within a couple of hours. Secondly despite the step by step detail (which is a good thing) your question is still not particularly easy to understand. And the reason for doing what you seem to be doing is even harder to understand.

charan wrote:Any suggestions the demo was for how to get Normal excel sheet data into TM1 database(to sliced excel sheet)

Given that a slice is a "normal" Excel sheet which merely contains TM1-specific formulas, it may be useful for you to expand on what your idea of a "normal" sheet is.

charan wrote:At the excel level under server

I really don't know what you mean by that.

charan wrote:I have cut a one cell value with DBRW formula and pasted it on Normal excel sheet. Then I entered value in sliced sheet in that particular slice and reflected back in Normal excel sheet and vice versa.

If I understand you correctly (which I may or may not), and let's leave aside all of the uploading to applications folders and publishing to web business for a minute, what you've done is:
- Taken a slice;
- Created a new workbook(?);
- Copied a DBRW cell to the new workbook;
- Changed a value in the slice;
- Saw that change reflected in the cell in the second workbook; but then later
- Did not see the second workbook's value.

If those assumptions are correct... where do you think the arguments of the second workbook's DBRW formula will be pointing to? They'll almost certainly be external references to the original slice worksheet in which case it would be surprising for you to see any values at all.

It might be better for you to describe exactly what your goal is here; not "to get formulas to work on a 'normal' Excel sheet", whatever that may be taken to mean, but what specific outcome you are trying to accomplish. If all you're trying to do is demonstrate that DBRW formulas do not have to come from slices, may I suggest the formula editor on the TM1 menu?

sorry Alan,

Here my requirement is Client has given me one work book, which has his own data, and this data to be loaded into TM1.

Client data is in one workbook with TEN different sheets, and we have taken Twenty slices from different TM1 cubes views.

Now I want to show him a demo how can he pull his data into TM1. That is what important and my requirement also.

In this scenario client data is not format of exact of any of TM1 cube view.

Thank you for your support Alan.

Hello

Please have a look at the DBSW (for numbers) and (if needed) the DBSS function (for Strings).

thank you,

I was trying with this in mean time DBSW(sheet1,C8!,$B$8,$C$8.....)

Sheet1 is the reference from client workbook and C8 is the cell number in this number, this is written in TM1 slice workbook

In TM1 slice work book, in one cell the formula I tried is

=DBSW(sheet1,c8!,$B$8,'...) this is an example

this will work..

charan wrote:thank you,

I was trying with this in mean time DBSW(sheet1,C8!,$B$8,$C$8.....)

Sheet1 is the reference from client workbook and C8 is the cell number in this number, this is written in TM1 slice workbook

In TM1 slice work book, in one cell the formula I tried is

=DBSW(sheet1,c8!,$B$8,'...) this is an example

this will work..

I'm still not 100% certain what your problem actually is...

but if this isn't working in TM1 web it is very likely due to the fact that references to other sheets in your workbook are better off being replaced with named ranges.

charan wrote:thank you,

I was trying with this in mean time DBSW(sheet1,C8!,$B$8,$C$8.....)

Sheet1 is the reference from client workbook and C8 is the cell number in this number, this is written in TM1 slice workbook

In TM1 slice work book, in one cell the formula I tried is

=DBSW(sheet1,c8!,$B$8,'...) this is an example

this will work..

What is c8! supposed to be in your DBSW formula?
Did you check the syntax and arguments (including the correct order of arguments) in functions like DBSW, DBRW, ... ?

Wim Gielis wrote:

charan wrote:thank you,

I was trying with this in mean time DBSW(sheet1,C8!,$B$8,$C$8.....)

Sheet1 is the reference from client workbook and C8 is the cell number in this number, this is written in TM1 slice workbook

In TM1 slice work book, in one cell the formula I tried is

=DBSW(sheet1,c8!,$B$8,'...) this is an example

this will work..

I really doubt that it will given that (as Wim alluded to) the bang operator (!) is used to separate a sheet name from a cell reference, and that therefore c8! is referring to an unspecified range on a worksheet named C8. (A sheet which probably doesn't exist, and even if it did it would have to be enclosed in single quotes.) In addition to which your first argument (which should be the value that you're sending) appears to be a sheet name though again that would be invalid.

In short, the formula that you describe can be nothing like any formula that would actually work.

Wim Gielis wrote:What is c8! supposed to be in your DBSW formula?
Did you check the syntax and arguments (including the correct order of arguments) in functions like DBSW, DBRW, ... ?

You'd also be far better off getting a copy of TM1 Tools and having it check the formulas for you.

Thank your support Alan,

Here I am enclosing two sheets what I was trying.

1) Slice of cube view/Sliced excel sheet

2) User data/Normal excel sheet.

I want pull user data values into slice of cube view. What I was trying earlier was I was using
=DBSW(userdata!,B7,$B$1,$B$2,$B$3.....)

My requirement exactly was user should be able to pull his data in any sheet into TM1 database(slice of cube view)

My interpretation is that you have a workbook from a user with 10 worksheets, the user wants to upload the data from all 10 worksheets into TM1 and you have a series of slice views which change based upon the user input data.

You have only provided one worksheet and this appears to be based around exchange rate uploading and your slice lists the Summary data which 'could' change based upon the exchange rates.

I'd suggest you change the process around and either; create an input view to your exchange rate cube in TM1, or, create an input template for your user to populate (one worksheet for user input numbers and second worksheet for DBRW/ DBSW)

Alternatively, if the user is pulling the exchange rate data from other system/ source you might want to consider a TI process

Edd

Thank you Edward,

Yes I cannot give those sheets because it is confidential.

User data is not TM1 format, but still the requirement is user data should be able to pull into TM1.

User data is not TM1 format in the sense, it does not belongs any particular view of TM1.

I have tried with DBRW, When I applied this function on User data. User data is not updated on TM1 web application.

When I applied DBSW, I am getting an " # Name?" this kind of image in that particular cell.

Hi Guys, thank you.

I have done it.

Hi Charan,

Can you let us know how you resolved this so future users searching for solutions can benefit from it,

Thanks,

Edd