Text data as a fact from cube

[Dineshpullagura]

Hello All,

Is it possible to use text data column from a fact table through dynamic cube in cognos report studio.

I have a fact table which stores customer's social media communication like twitter posts. I want to show them in the report.

I built a cube on that fact table. But in my report studio i am not able to view the text. Is there any other approach i can follow to get the text in my fact table from the cube.

Thanks,

[bus_pass_man]

Text data isn't really something which is classifiable as a fact.

Counts of text data and other non-numeric data types are facts.

Create a degenerate dimension and put them in it.   Or since the data is associated with customers, you might want to add the column as a level in your Customer dimension.  It all depends on what you want to do with the data. 

It also depends on the data.  You could have 1.n social media tweets etc. associated with some thing.  I don't know what other things you have in your fact table or you're calling the table which is storing the social media stuff a fact table.  I'm guessing the table is storing a record for each tweet etc.  Besides your customer dimension, what other dimensions are associated with this table?

[Dineshpullagura]

Hi,

Thanks for your reply.

I have the social media data in a table which is my fact table. Customer, date and type of social media are the dimensions for this.

Yeah the table stores a record for each tweet(1.n), or a face book post in the table. I want to display these tweets or face book posts in the report for each customer along with the date.

I think degenerate dimension is a better approach.

Thanks for your time.