November 24, 2014 at 3:21 am
Hello everyone,
I have created a SSAS tabular which i have deployed. Now when i login from SSMS i see there are 2 database are there
1. Sales (Actual database)
2. Sales_BI_DEV_123445 (workspace database).
Now my problem is when i connect with SSAS using excel data source i see both the database and every time the workspace database is updated not the original one which gives me wrong data.
Can any one help what can be done in this regards.
Thanks.
Deepika
November 24, 2014 at 9:33 pm
please reply somebody :crazy:
November 25, 2014 at 1:14 am
You need to process the entire database, not just the workspace one.
http://msdn.microsoft.com/en-us/library/hh758414.aspx
November 25, 2014 at 2:05 am
Thanks!!
I do 'Process All' for my cube. but still the same issue.
Other than that i dont want to show the stake holders multiple database when they connect with Excel to cube db.
please suggest on the same
Regards,
Deepika
November 25, 2014 at 2:08 am
What I mean is you need to process the whole AS database, not just the cube.
As for restricting what is seen in excel when a user connects, you can achieve this using Role-Based Security (http://msdn.microsoft.com/en-gb/library/hh213165.aspx)
November 25, 2014 at 2:12 am
Thanks for the same!!
Quick questions :
1. How to process whole SSAS database : In SSIS, i can see option of processing only Cube
2. Every time processing the whole db can create problem right? the data size will keep increasing
3. In MDX, we can use 'replace' for replacing fact table but in tabular how can i replace the fact table.
kindly suggest on the same
Thanks a lot for your help!!
November 25, 2014 at 2:18 am
er.deepikagoyal (11/25/2014)
Thanks for the same!!Quick questions :
1. How to process whole SSAS database : In SSIS, i can see option of processing only Cube
2. Every time processing the whole db can create problem right? the data size will keep increasing
3. In MDX, we can use 'replace' for replacing fact table but in tabular how can i replace the fact table.
kindly suggest on the same
Thanks a lot for your help!!
1. In the object list in the AS processing task, when you click add you have an option to add what object gets processed. Choose the entire database.
2. No. If you are doing a full process you are unprocessing and reprocessing - the size will grow as your data grows but you are not just piling it on top each time.
3. There is no such function in MDX. What do you specifically mean?
November 25, 2014 at 2:23 am
1. In the object list in the AS processing task, when you click add you have an option to add what object gets processed. Choose the entire database.
Thanks 🙂
2. No. If you are doing a full process you are unprocessing and reprocessing - the size will grow as your data grows but you are not just piling it on top each time. Thanks 🙂
3. There is no such function in MDX. What do you specifically mean?
i will write down my case.
I have created a tabular cube which is working fine. then i created another tabular cube on the similar line of previous cube (using Import/Export wizard). Now i want to replace fact table of second cube with other fact table. i cant see any option in tabular cube to replace fact table.
November 25, 2014 at 2:42 am
No!! i cant do like that.
See i have a reference cube which i have made first (Sales) which has all calculated column, measures , relationships defined on the fact.
Same kind of 15 cubes(sales1, sales2 ... n) i have to design only the fact table is going to change. So i was thinking of creating 15 cubes using import/export wizard and then replace fact table in every cube with the original one (Every cube will have different fact table)
So now to replace fact table i cant see any option. Do i have to define same
calculated column, measures , relationships 15 times ? :w00t:
November 25, 2014 at 2:46 am
Okay, this is tabular right? Even if it's multi-dimensional you don't need a separate cube for each fact table. You can have 1 cube and use either perspectives (http://msdn.microsoft.com/en-us/library/gg492105.aspx) or role based security to limit what users can see.
Just to clarify my wording above - I'm not suggesting that perspectives "limit" what users can see, role based security can but perspectives are used to separate a cube into smaller, focused areas of a business (e.g. You might have a "Sales" cube and have a perspective for "Internet Sales" and one for "Mail Order Sales") which users can then connect to but they do not replace security.
November 25, 2014 at 2:53 am
Yes!!! it's a Tabular cube.
Agree with you that we don't need separate cube for fact table.
But my manager wants to have different cube for different fact table (His own concerns :angry: )
That's the reason i have landed up making 15 different cubes. any solution for replacing fact table
November 25, 2014 at 3:00 am
er.deepikagoyal (11/25/2014)
But my manager wants to have different cube for different fact table (His own concerns :angry: )That's the reason i have landed up making 15 different cubes. any solution for replacing fact table
Your manager is an idiot. Not only will this take up needless storage space it will also be a nightmare to maintain (imagine what happens when a new column is added to a dimension table, you'd have to make this change 15 times). In what universe is that an acceptable support model? I'd say you need to stand up to your manager on this as they clearly don't understand the technology. But....
If you are being made to create 15 separate cubes then I don't know a quick way of simply copying one cube and replacing the fact table with another in tabular. Sorry.
November 25, 2014 at 3:03 am
Your manager is an idiot :hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe::hehe:
I know!!
Well let me figure out!
Thanks a lot for your grt help! 😀
Viewing 14 posts - 1 through 13 (of 13 total)
You must be logged in to reply to this topic. Login to reply