SSAS project error while executing CUBE manually
I am trying to execute CUBE manually from VisualStudio. But getting an error/warning at last. Actually I am new to SSAS Project. So could not understand the last message popup whether it successfully ran or not!
Could anyone please guide me for below Snapshot!
Why ① is looking like errors but ② is showing it as "Process succeeded". Is there any problem in my CUBE or its just because of the warning? may I need to consider it as any serious issue?
Edited: I have updated the Image as my Error messages counts reduced and even column name also changed without doing anything on the CUBE.
sql-server runtime-error ssas business-intelligence asked Nov 12 at 8:43
im_one
379116
|
show 1 more comment
I am trying to execute CUBE manually from VisualStudio. But getting an error/warning at last. Actually I am new to SSAS Project. So could not understand the last message popup whether it successfully ran or not!
Could anyone please guide me for below Snapshot!
Why ① is looking like errors but ② is showing it as "Process succeeded". Is there any problem in my CUBE or its just because of the warning? may I need to consider it as any serious issue?
Edited: I have updated the Image as my Error messages counts reduced and even column name also changed without doing anything on the CUBE.
sql-server runtime-error ssas business-intelligence asked Nov 12 at 8:43
im_one
379116
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
2
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32
|
show 1 more comment
I am trying to execute CUBE manually from VisualStudio. But getting an error/warning at last. Actually I am new to SSAS Project. So could not understand the last message popup whether it successfully ran or not!
Could anyone please guide me for below Snapshot!
Why ① is looking like errors but ② is showing it as "Process succeeded". Is there any problem in my CUBE or its just because of the warning? may I need to consider it as any serious issue?
Edited: I have updated the Image as my Error messages counts reduced and even column name also changed without doing anything on the CUBE.
sql-server runtime-error ssas business-intelligence asked Nov 12 at 8:43
im_one
379116
I am trying to execute CUBE manually from VisualStudio. But getting an error/warning at last. Actually I am new to SSAS Project. So could not understand the last message popup whether it successfully ran or not!
Could anyone please guide me for below Snapshot!
Why ① is looking like errors but ② is showing it as "Process succeeded". Is there any problem in my CUBE or its just because of the warning? may I need to consider it as any serious issue?
Edited: I have updated the Image as my Error messages counts reduced and even column name also changed without doing anything on the CUBE.
sql-server runtime-error ssas business-intelligence sql-server runtime-error ssas business-intelligence asked Nov 12 at 8:43
im_one
379116
asked Nov 12 at 8:43
im_one
379116
edited Nov 14 at 6:29
asked Nov 12 at 8:43
im_one
379116
asked Nov 12 at 8:43
im_one
379116
asked Nov 12 at 8:43
im_one
379116
379116
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
2
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32
|
show 1 more comment
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
2
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
2
2
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32
|
show 1 more comment
1 Answer
1
active
oldest
votes
There is a difference between NULL/BLANK and the value '' (which is an empty string). It looks like you have an empty string in the column BU_CODE in your measure group table and no key value '' (empty string) in your dimension table. Maybe I'm wrong but I sugggest you modify the value in your measure group table (change the '' by the correct value if the empty string is not) or you have to add this possible value in a new row of your dimension
answered Nov 14 at 9:04
NickNick
1698
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53258476%2fssas-project-error-while-executing-cube-manually%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
There is a difference between NULL/BLANK and the value '' (which is an empty string). It looks like you have an empty string in the column BU_CODE in your measure group table and no key value '' (empty string) in your dimension table. Maybe I'm wrong but I sugggest you modify the value in your measure group table (change the '' by the correct value if the empty string is not) or you have to add this possible value in a new row of your dimension
answered Nov 14 at 9:04
NickNick
1698
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
add a comment |
There is a difference between NULL/BLANK and the value '' (which is an empty string). It looks like you have an empty string in the column BU_CODE in your measure group table and no key value '' (empty string) in your dimension table. Maybe I'm wrong but I sugggest you modify the value in your measure group table (change the '' by the correct value if the empty string is not) or you have to add this possible value in a new row of your dimension
answered Nov 14 at 9:04
NickNick
1698
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
add a comment |
There is a difference between NULL/BLANK and the value '' (which is an empty string). It looks like you have an empty string in the column BU_CODE in your measure group table and no key value '' (empty string) in your dimension table. Maybe I'm wrong but I sugggest you modify the value in your measure group table (change the '' by the correct value if the empty string is not) or you have to add this possible value in a new row of your dimension
answered Nov 14 at 9:04
NickNick
1698
There is a difference between NULL/BLANK and the value '' (which is an empty string). It looks like you have an empty string in the column BU_CODE in your measure group table and no key value '' (empty string) in your dimension table. Maybe I'm wrong but I sugggest you modify the value in your measure group table (change the '' by the correct value if the empty string is not) or you have to add this possible value in a new row of your dimension
answered Nov 14 at 9:04
NickNick
1698
answered Nov 14 at 9:04
NickNick
1698
answered Nov 14 at 9:04
NickNick
1698
answered Nov 14 at 9:04
NickNick
1698
1698
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
add a comment |
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
Thanks for the help!! I have changed the value and now its working like a charm!
– im_one
Nov 15 at 2:21
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53258476%2fssas-project-error-while-executing-cube-manually%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
I guess they are warnings. But, you should be able to extend the error message clicking on the "+". Deppending on the issue and your knowledge about the architecture of your cube, you may decide if you 'ignore' those or not. Just by curiosity, can we get a screenshot about the extended error ?
– NickNick
Nov 12 at 9:06
@NickNick: Thank you for the Comment. I have updated the question with Warning messages. Please ask in case of Error messages are not readable!
– im_one
Nov 13 at 1:14
Ok, I guess you have/you want a link between your measure group DC_something and the dimension "Cal Ym". So you should have a link between the column 'Cal_YM' in the table dbo_something and the table used to create the dimension CalYM. If I were you... first, I would check, in the "dimension usage" (in visual studio), if the link between measure group and dimension is correct. Second, why the attribute you're using from the dimension side doesn't reference some values you have in the measure group (ex: 201809). When you process the cube, is it a "full process" ?
– NickNick
Nov 13 at 9:18
2
sorry, looking on your screenshot, I have my answer about the process "full process" or not... Maybe that a solution is to reprocess the dimension too ... in order to update it for the new values you can find inside
– NickNick
Nov 13 at 10:00
@NickNick: Thanks a lot for your support and i really appreciate. Today I have rerun the CUBE and all errors are gone except last one, which i have updated in image. Recent errors count was '3040732'(all data) and not it's only '1'. But column name has been changed. Recent error was about 'CalYM' not it is changed to another one as 'BU_CODE'. Is there any clue on this?
– im_one
Nov 14 at 6:32