 | |
Re: How to change the source of a fact table
microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: How to change the source of a fact table -
12-06-2006
, 01:11 PM
|
Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
#2
| |||
| |||
|
|
Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
#3
| |||
| |||
|
|
Hi Vimas: Thanks a lot. It works. But in the cube tab it is still saying the old fact table name. Is there anyway to change that?? Thanks again!! -- Arale "Vimas" wrote: Try to go to the partitions tab, then select measure group you want to change and change source. If tables have exactly same structure, you'll see new table availalbe in the list. "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:1BB2FB8B-3321-4CB7-B923-AFD6E0BC0320 (AT) microsoft (DOT) com... Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
#4
| |||
| |||
|
|
Hi Vimas: Thanks a lot. It works. But in the cube tab it is still saying the old fact table name. Is there anyway to change that?? Thanks again!! -- Arale "Vimas" wrote: Try to go to the partitions tab, then select measure group you want to change and change source. If tables have exactly same structure, you'll see new table availalbe in the list. "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:1BB2FB8B-3321-4CB7-B923-AFD6E0BC0320 (AT) microsoft (DOT) com... Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
#5
| |||
| |||
|
|
I am sorry. What I mean is in the cube structure tab, in the data source view window where it show the visual structure of the cube. It still shows the old fact table name even it is using the new fact table. Is there any way to change that ? -- thanks Arale "Vimas" wrote: I am not sure I understood what you mean. But lets try: In the cube structure tab select measure group that you want to rename, then in properties change name property (or F2 and rename in place). You'll not be able to replace ID property though. I usually change ID by selecting cube, right mouse click, then "View Code" and change XML code, but this is sensitive and you have to make sure you changed ID in all related places. I would not recommend changing ID. Regards, "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:7BF58CAB-06FC-4B19-9149-35DE81E2B211 (AT) microsoft (DOT) com... Hi Vimas: Thanks a lot. It works. But in the cube tab it is still saying the old fact table name. Is there anyway to change that?? Thanks again!! -- Arale "Vimas" wrote: Try to go to the partitions tab, then select measure group you want to change and change source. If tables have exactly same structure, you'll see new table availalbe in the list. "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:1BB2FB8B-3321-4CB7-B923-AFD6E0BC0320 (AT) microsoft (DOT) com... Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
#6
| |||
| |||
|
|
Try this: Go to data source view (if in cube editor select table and then "Edit data source view"), select fact table change change friendly name property of that table. I am sure you already did this: Right mouse click on the table (in data source view), then "Replace Table" then select option that suits you. "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:3B9896EF-E67E-45A5-9AAD-5770951B9715 (AT) microsoft (DOT) com... I am sorry. What I mean is in the cube structure tab, in the data source view window where it show the visual structure of the cube. It still shows the old fact table name even it is using the new fact table. Is there any way to change that ? -- thanks Arale "Vimas" wrote: I am not sure I understood what you mean. But lets try: In the cube structure tab select measure group that you want to rename, then in properties change name property (or F2 and rename in place). You'll not be able to replace ID property though. I usually change ID by selecting cube, right mouse click, then "View Code" and change XML code, but this is sensitive and you have to make sure you changed ID in all related places. I would not recommend changing ID. Regards, "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:7BF58CAB-06FC-4B19-9149-35DE81E2B211 (AT) microsoft (DOT) com... Hi Vimas: Thanks a lot. It works. But in the cube tab it is still saying the old fact table name. Is there anyway to change that?? Thanks again!! -- Arale "Vimas" wrote: Try to go to the partitions tab, then select measure group you want to change and change source. If tables have exactly same structure, you'll see new table availalbe in the list. "Arale" <Arale (AT) discussions (DOT) microsoft.com> wrote in message news:1BB2FB8B-3321-4CB7-B923-AFD6E0BC0320 (AT) microsoft (DOT) com... Hi: I have an existing cube that I made a copy of it. However, I want the new cube to point to another fact table instead of the old one. All the dimenstion and measures should stay the same. How do I do it? I already added the new fact table in the data source view -- Thanks in advaice!! Arale |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.