Grouping table columns by Business names

[#1]

Hi Gurus,

Grouping column by subject area from single fact table.

My fact (FACT1) table has six columns col1,col2,col3,col4,col5,col6. joined with all the dimensions.

FACT1:

col1,

col2,

col3,

col4,

col5,

col6.

Now i want to group columns of the FACT1 into  Actuals and Bugets. When user opens the document, want to see table names and columns as follows.

Actuals:

col1,

col2,

col3

Budgets:

col4,

col5,

col6.

Please suggest me approach to provide solution to user.

Thanks,

Sherry

[sunny_talwar]

Not sure what you mean group? Are you trying to create a cycle or dirll-down group for a table? Can you share an example to understand your requirement?

Best,

Sunny

[sinanozdemir · Accepted solution]

Maybe try something like this. I am just guessing since we don't have an excerpt of your script or data:

Data model will have two tables:

Hope this helps.