How to move values in a column group to column headings and display values in table, Oracle OTBI
I'm putting together a report in Oracle BI Publisher that needs to display project details and cost analysis. However, some of the project details are showing up as a group in a column instead of as their own column heading in the table.
I've tried to duplicate the columns and filter for each category (Class code 1 = value, Class code 2 = value, Department = value, Region = value); however, I am unable to make them as independent filters.
How do you move the groups to column headings or to create duplicate columns and independent filers?
I've attached what I'm working with and an Excel sheet of what I hope to achieve.
Column selection from subject area analysis:
Current output of the Report/ class category as a group:
Output goal, group values as column headings:
text-formatting cloud oracle-12c
edited Jan 24 at 1:14
Scott
15.9k113990
asked Jan 23 at 22:36
AliAli
11
add a comment |
I'm putting together a report in Oracle BI Publisher that needs to display project details and cost analysis. However, some of the project details are showing up as a group in a column instead of as their own column heading in the table.
I've tried to duplicate the columns and filter for each category (Class code 1 = value, Class code 2 = value, Department = value, Region = value); however, I am unable to make them as independent filters.
How do you move the groups to column headings or to create duplicate columns and independent filers?
I've attached what I'm working with and an Excel sheet of what I hope to achieve.
Column selection from subject area analysis:
Current output of the Report/ class category as a group:
Output goal, group values as column headings:
text-formatting cloud oracle-12c
edited Jan 24 at 1:14
Scott
15.9k113990
asked Jan 23 at 22:36
AliAli
11
add a comment |
I'm putting together a report in Oracle BI Publisher that needs to display project details and cost analysis. However, some of the project details are showing up as a group in a column instead of as their own column heading in the table.
I've tried to duplicate the columns and filter for each category (Class code 1 = value, Class code 2 = value, Department = value, Region = value); however, I am unable to make them as independent filters.
How do you move the groups to column headings or to create duplicate columns and independent filers?
I've attached what I'm working with and an Excel sheet of what I hope to achieve.
Column selection from subject area analysis:
Current output of the Report/ class category as a group:
Output goal, group values as column headings:
text-formatting cloud oracle-12c
edited Jan 24 at 1:14
Scott
15.9k113990
asked Jan 23 at 22:36
AliAli
11
I'm putting together a report in Oracle BI Publisher that needs to display project details and cost analysis. However, some of the project details are showing up as a group in a column instead of as their own column heading in the table.
I've tried to duplicate the columns and filter for each category (Class code 1 = value, Class code 2 = value, Department = value, Region = value); however, I am unable to make them as independent filters.
How do you move the groups to column headings or to create duplicate columns and independent filers?
I've attached what I'm working with and an Excel sheet of what I hope to achieve.
Column selection from subject area analysis:
Current output of the Report/ class category as a group:
Output goal, group values as column headings:
text-formatting cloud oracle-12c
text-formatting cloud oracle-12c
edited Jan 24 at 1:14
Scott
15.9k113990
asked Jan 23 at 22:36
AliAli
11
edited Jan 24 at 1:14
Scott
15.9k113990
asked Jan 23 at 22:36
AliAli
11
edited Jan 24 at 1:14
Scott
15.9k113990
edited Jan 24 at 1:14
Scott
15.9k113990
edited Jan 24 at 1:14
Scott
15.9k113990
15.9k113990
asked Jan 23 at 22:36
AliAli
11
asked Jan 23 at 22:36
AliAli
11
asked Jan 23 at 22:36
AliAli
11
11
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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%2fsuperuser.com%2fquestions%2f1397670%2fhow-to-move-values-in-a-column-group-to-column-headings-and-display-values-in-ta%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- 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%2fsuperuser.com%2fquestions%2f1397670%2fhow-to-move-values-in-a-column-group-to-column-headings-and-display-values-in-ta%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
